eliminating empty cells from chart area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of 21 cells that are tracked for values on another spread
sheet at different times not all of the cells will have values this changes
daily. I only want to chart the cells that have a value in that cell range
but my charts keep showing the empty cells, any suggestions would be greatly
appreciated
 
You must log in or register to reply here.

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

Similar Threads

Auto expanding X Axis for Chart 2
linear charting with zeros 7
Chart displaying "blank" cells? 13
HOW THE HELL Can I get excell to stop ploting blank cells 4
Dynamic Chart (OFFSET Function) plots empty cells. 3
Abstracting Error Bar Data From Charts 3
VBA set thick borders around non empty cells in range 0
Control in Chart Sheet 6

Back
Top