How do I only add every other month to my chart

K

kmt1984

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!
 
T

trip_to_tokyo

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.
 
J

JR Hester

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to chart months by financial year 0
Chart is only showing every other month 2
Table within a chart 4
How to create a bubble chart with more than 2 variables 0
chart to SUM mileage over months 1
Including Totals in Chart's data table 1
Month as Axis entry 1
How do I add text to a chart? 1

Top