{snip}
Seems like a flaw in excel if you ask me...
K
I have a typical Line chart that displays the values as they are reduced on another sheet. If I hide the columns that the values are in on the other sheet my line graph disappears.
How do I fix this and still hide the columns with the data?
Select the chart, then Tools | Options... | Chart tab. Unchecked the 'Plot visible cells only'.
Does that fix your problem? Or is it something else?
I have a typical Line chart that displays the values as they are reduced on another sheet. If I hide the columns that the values are in on the other sheet my line graph disappears.
How do I fix this and still hide the columns with the data?