Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding 0 values in line charts
I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has data for the weeks-to-date. How can I chart this data on a line graph-- showing comparison between the two years--and not chart the zero values? Thanks! |
#2
|
|||
|
|||
1) Fill empty cell with =NA(), OR
2) Click on chart to activate; use Tools|Options-Chart and specify how empty cell are to be treated, OR c) Use dynamic chart: see the Excel Tips & Tricks page on my website best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Teri" wrote in message ... I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has data for the weeks-to-date. How can I chart this data on a line graph-- showing comparison between the two years--and not chart the zero values? Thanks! |
#3
|
|||
|
|||
Thanks for your response! Actually, the cells aren't empty; they contain
zeroes. Consequently, I wrote an IF statement and they now have N/A in them. Teri "Bernard Liengme" wrote: 1) Fill empty cell with =NA(), OR 2) Click on chart to activate; use Tools|Options-Chart and specify how empty cell are to be treated, OR c) Use dynamic chart: see the Excel Tips & Tricks page on my website best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Teri" wrote in message ... I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has data for the weeks-to-date. How can I chart this data on a line graph-- showing comparison between the two years--and not chart the zero values? Thanks! |
#4
|
|||
|
|||
"Bernard Liengme" wrote in message ... 1) Fill empty cell with =NA(), OR 2) Click on chart to activate; use Tools|Options-Chart and specify how empty cell are to be treated, OR c) Use dynamic chart: see the Excel Tips & Tricks page on my website best wishes -- Bernard V Liengme Hello Bernard. My case seems to be a little different but related maybe. I have a simple chart that tracks thermistor readings at known temperatures: x axis = temperature (24 - 60 deg. F) and y axis = K Ohms. I put my resistance reading in the cell that corresponds to my temperature at the time. My problem is that I want my line chart to show cells 22 - 62 and not include cells 1 - 21. Not sure how to do this. Can you nudge me in the right direction please? |
#5
|
|||
|
|||
If I understand the question correctly, all you need do is change the source
for the chart. Click on chart; look at the coloured 'range finder' lines around the cells that are use to make the chart; drag the top of these down to the first cell to be used. Send me the file (my email not the group) if you are unsuccessful best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Slippery_one" wrote in message ... "Bernard Liengme" wrote in message ... 1) Fill empty cell with =NA(), OR 2) Click on chart to activate; use Tools|Options-Chart and specify how empty cell are to be treated, OR c) Use dynamic chart: see the Excel Tips & Tricks page on my website best wishes -- Bernard V Liengme Hello Bernard. My case seems to be a little different but related maybe. I have a simple chart that tracks thermistor readings at known temperatures: x axis = temperature (24 - 60 deg. F) and y axis = K Ohms. I put my resistance reading in the cell that corresponds to my temperature at the time. My problem is that I want my line chart to show cells 22 - 62 and not include cells 1 - 21. Not sure how to do this. Can you nudge me in the right direction please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppress zero values in line charts? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
suppress zero values in line charts? | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |