In this tutorial you learn 4 tricks:
- How to prevent your line series from dropping to zero.
- How to create dynamic charts based on a Point of View (in this case month selection which is controlled by a data validation list).
- How to integrate your legend inside the chart – i.e. at the end of the line series for improved readability. This generally is not a problem if your series is fixed to a certain number of categories (for example for Budget data we generally have 12 months available). But for a dynamic series such as Actual data, the series expands as the data for the next months come in. In this case we need to use a trick to get the legend, move with the series as the line gets longer.
- How to hide or make error values in cells invisible with conditional formatting.
Feel free to Download the Workbook HERE.
Published on: December 1, 2017
Last modified: May 29, 2024
Leila Gharani
I’ve spent over 20 years helping businesses use data to improve their results. I've worked as an economist and a consultant. I spent 12 years in corporate roles across finance, operations, and IT—managing SAP and Oracle projects.
As a 7-time Microsoft MVP, I have deep knowledge of tools like Excel and Power BI.
I love making complex tech topics easy to understand. There’s nothing better than helping someone realize they can do it themselves. I’m always learning new things too and finding better ways to help others succeed.
