Scrollable line chart data

[antmoss3]

Hi all

When preparing data for a scrollable line chart - what if the values are different for example I have 5 x KPIs and 2 are percentages % and 3 are values £'s - can I still use one table and the cell format changes in the charts based on the KPI I select or is this not possible? From experience the chart/data can only deal with one number formatting type...

Thanks

[Andy Pope]

If you are using a set of cells to display a chosen KPI then you will have trouble with the mixture of £ and %.

If you use a named range to specify the source cells the chart will pickup the formatting of the cells and can automatically switch between £ and %