Not plotting blank cells in a chart.

G

Guest

I am trying to show a plotted line graph in Excel. If I have example data in
cells A1 – A5, and then make a plotted line graph from source data A1-A80. I
would like the graph to ONLY show the data plotted in A1-A5, until I add data
in A6. Once I add data in A6, A7, A8, etc, I would like the graph to only
plot the data that has values filled in the cells. Right now if I have
source data from A1-A80, and actual values only in A1-A5, it will plot the
values in A1-A5, and then my line goes to 0 for A6-A80. I am looking to have
the graph only chart the cells with values in them. I am looking for a way
to do this without changing the source data each time I add new data to a
cell. Any help????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top