M
Matt Kruse
Excel2000
Example file: http://www.mattkruse.com/temp/chart.xls
I'm not new to Excel, but two things have always bugged me and I've never
taken the time to figure out the correct answers. Can anyone help?
1) In the example file above, I have place-holders for 2 sets of data in my
chart. Is it possible to tell the chart NOT to plot a data series if it
doesn't contain any values? In other words, I'd like the chart to optionally
show 4 lines, if the data exists. But if data only exists for 1 line, don't
show the others in the legend at all. Possible?
2) In the example file, I have created defined names for a dynamic range of
values for the chart using OFFSET and COUNTA. Works fine. EXCEPT when there
are no values there at all. I get the message "Your formula contains an
invalid external reference to a worksheet" when the worksheet opens or when
anything is changed. How can I supress this error, and make the chart just
show nothing? I often work on worksheets where data is empty but will be
filled in later, and I want the charts to immediately respond and update.
Thanks!!
Example file: http://www.mattkruse.com/temp/chart.xls
I'm not new to Excel, but two things have always bugged me and I've never
taken the time to figure out the correct answers. Can anyone help?
1) In the example file above, I have place-holders for 2 sets of data in my
chart. Is it possible to tell the chart NOT to plot a data series if it
doesn't contain any values? In other words, I'd like the chart to optionally
show 4 lines, if the data exists. But if data only exists for 1 line, don't
show the others in the legend at all. Possible?
2) In the example file, I have created defined names for a dynamic range of
values for the chart using OFFSET and COUNTA. Works fine. EXCEPT when there
are no values there at all. I get the message "Your formula contains an
invalid external reference to a worksheet" when the worksheet opens or when
anything is changed. How can I supress this error, and make the chart just
show nothing? I often work on worksheets where data is empty but will be
filled in later, and I want the charts to immediately respond and update.
Thanks!!