So to put this in layman's terms:
I am trying to make a line chart that only takes the data calculated from formulas. (See attachments)
While ignoring the (lack of data) in other areas due to the formula defaulting to no data.
Currently I have the formulas defaulting to "#N/A" instead of "0" and even if I had just 0's the data is still tabulated.
I am trying to make a chart that only takes the data that is there, as I will be entering a lot of data and the formulas will be auto calculating.
I want the chart to adjust in response to the presence of new data.
The example I am using has 6 data points for each line, but also counts the missing 9 data points. I want it to just tabulate whatever data is there.
So if there are only 3 data points then I want the chart to only show 3 data points for each line, the same for 12 data points, etc. etc.
I've almost no experience using Macros and VBA. So I don't even know where to begin with making a macro if that is the best solution.
(This image is if I select all the relevant cells to create a chart)
Graph 1.png
This second image is if I ONLY select 6)
Graph 2.png
Thanks
Bookmarks