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
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
