| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis jan - dec, but data only until may
How can I get the whole year to show on my line graph but only show months
with data? I do not want the line to go down to zero, I just want it to stop on May. Any ideas? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x axis jan - dec, but data only until may
Put =NA() in the cells for the later months.
-- David Biddulph "erock" wrote in message ... How can I get the whole year to show on my line graph but only show months with data? I do not want the line to go down to zero, I just want it to stop on May. Any ideas? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x axis jan - dec, but data only until may
That was so money! Thanks a bunch!
"David Biddulph" wrote: Put =NA() in the cells for the later months. -- David Biddulph "erock" wrote in message ... How can I get the whole year to show on my line graph but only show months with data? I do not want the line to go down to zero, I just want it to stop on May. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
| rotate data from x axis to y axis | New Users to Excel | |||
| Data points going from axis to axis | Charts and Charting in Excel | |||
| In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
| Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
Linear Mode
