hi there,
The attached sheet is just a dummy to work on, from which I will implement what I've learned here onto my actual sheets.
Two things need to happen here1) The graph must only show the populated months, as the rest of the months are filled in, the graph must resize automatically.
(2) If cell N1 is changed to a 1, some of the graph data change to zeros, however, the legends are still showing for these fields. So the legends need to also adapt to only show the active fields.
I have found examples of how to achieve more or less what I am after, although the examples were (are) for 1 column data only, and pie graphs.
I require a line graph. Any help will honestly be very highly appreciated..
Bookmarks