| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hide one month in a chart
I have data from July 2006 to January 2007 that I need to chart. The
only catch is that there is no data for Dec 06 (we do not capture this data due to the Xmas rush). On the chart I would like to remove Dec 06 but have not succeeded. Any ideas? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hide one month in a chart
In the cell where the Dec 6 data should go type =NA()
This will display as #N/A Excel will ignore it when it charts But Dec 6 will still be on the x-axis (it would be misleading to not have it) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... I have data from July 2006 to January 2007 that I need to chart. The only catch is that there is no data for Dec 06 (we do not capture this data due to the Xmas rush). On the chart I would like to remove Dec 06 but have not succeeded. Any ideas? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Hide one month in a chart
Hide the row?
-- Don Guillett SalesAid Software wrote in message ups.com... I have data from July 2006 to January 2007 that I need to chart. The only catch is that there is no data for Dec 06 (we do not capture this data due to the Xmas rush). On the chart I would like to remove Dec 06 but have not succeeded. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter variable data into a formula | Excel Discussion (Misc queries) | |||
| pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
| hide original cells after creating chart | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Linear Mode
