In this tutorial you learn 4 tricks:

  1. How to prevent your line series from dropping to zero.
  2. How to create dynamic charts based on a Point of View (in this case month selection which is controlled by a data validation list).
  3. 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.
  4. How to hide or make error values in cells invisible with conditional formatting.

Feel free to Download the Workbook HERE.

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.