![]() |
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! |
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! |
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! |
All times are GMT +1. The time now is 05:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com