[...] 5 ways to use formulas in Conditional Formatting Custom Data Validation with Excel Formulas: Example 1, Example 2, More Make your charts smarter with Formulas [...]
Today we will learn how to make the chart legends smarter so that they provide more meaning and context to the chart, like this:
UNLIMITED PORTFOLIOS - ChartSmart allows you to create an unlimited number of portfolios. The simple portfolio manager allows you to enter the number of shares you own of specific securities then your portfolio is updated automatically when you do a data update. Each portfolio allows you to get a total summary for the day of the total value and individual profit and loss for each security. It even shows the change in the value of your portfolio from the previous day.