Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I eliminate empty cells from plotting on chart
How do I eliminate empty cells from plotting zeros on my chart?
I am working on a simple chart that plots weight loss on Y axis and date on X axis. I plot my weight values that I record once a week. The data series is part of a spreadsheet that records diet information on a daily basis. However, because the series of values had six empty cells between weight values, the chart shows each weight value okay but in between you see six zero values. When displaying the chart I go to tools options/chart tab and under plot empty cells as, I click on Plot empty cells as not plotted, and Plot visible cells only, but I still get all the empty cells in the series plotted as zero values. The only way I can eliminate these zero/empty plots is to set Format Axis/Scale Minimum above zero. But I want the Y axis to show, start at zero. I am using Excel 2002. TIA |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I eliminate empty cells from plotting on chart
Hi
Try setting the empty cells to =NA() They will then be ignored by the chart -- Regards Roger Govier "T. Duprex" <tduprexATlandmark.net wrote in message ... How do I eliminate empty cells from plotting zeros on my chart? I am working on a simple chart that plots weight loss on Y axis and date on X axis. I plot my weight values that I record once a week. The data series is part of a spreadsheet that records diet information on a daily basis. However, because the series of values had six empty cells between weight values, the chart shows each weight value okay but in between you see six zero values. When displaying the chart I go to tools options/chart tab and under plot empty cells as, I click on Plot empty cells as not plotted, and Plot visible cells only, but I still get all the empty cells in the series plotted as zero values. The only way I can eliminate these zero/empty plots is to set Format Axis/Scale Minimum above zero. But I want the Y axis to show, start at zero. I am using Excel 2002. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cahrt do not want plotting of empty cells | Charts and Charting in Excel | |||
Eliminate zero value cells in an EXCEL chart | Charts and Charting in Excel | |||
eliminate zero value cells from a chart in Excel | Charts and Charting in Excel | |||
Can I avoid plotting 'non-empty' cells | Charts and Charting in Excel | |||
Eliminate empty cells in data range | Excel Discussion (Misc queries) |