Dynamic charts with Formulas

[Raanan]

Good day,

I've been creating dynamic charts when the data is input the chat updates with the months which I have got my head around. However, what I need to work out now is if you can have a dynamic chart with formulas.

for example I have a raw data file, and there are formulas in a table that once this data file is updated the tables does too.


however, because there is a formula in the blank months the dynamic chart still adds the month in.


Is there a way around this?

 

[pgc01]

Hi

Sorry but your post is not clear to me.

Maybe you can post an example, just some cells would probably be enough, with

- the location of those cells
- their values and formulas (in case they have formulas)
- the names you defined as well as their definitions
- what you enter for the chart data

... and other informations you deem relevant

Also you may want to read this:

http://peltiertech.com/WordPress/dynamic-charts/