| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I only add every other month to my chart
I have totals for each month for several years, but I would like to just show
every other month on my chart. Is this possible, if so can you explain. Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I only add every other month to my chart
EXCEL 2007.
I don't know how realistic this is as I have not seen your data but one possibility is that you could set it up as a Pivot Chart. In the PivotChart Filter Pane you can then select / de-select whichever time frames you like. Please hit yes if my comments have helped. Thanks. "kmt1984" wrote: I have totals for each month for several years, but I would like to just show every other month on my chart. Is this possible, if so can you explain. Thanks! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I only add every other month to my chart
You did not specify which version of Excel you are working with.
IOne possiblity follows. 2007 and 2002 versions allow you to select multiple individual data ranges. Hold Control key as you select the individual months data you wish charted. HTH "kmt1984" wrote: I have totals for each month for several years, but I would like to just show every other month on my chart. Is this possible, if so can you explain. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart is only showing every other month | Charts and Charting in Excel | |||
| Bar chart by month | Charts and Charting in Excel | |||
| Hide one month in a chart | Charts and Charting in Excel | |||
| 3 month rolling chart | Charts and Charting in Excel | |||
| adding new month to chart | Charts and Charting in Excel | |||
Linear Mode
