Chart from nonadjacent selections

[ar76]

I am trying to create a chart using nonadjacent selections and the chart
wizard does not seem to be representing the data in a way I can
understand. It has worked fine for two previous charts - producing a
column chart showing a comparison between two sets of figures across a
number of weeks. This time the chart wizard seems to be spreading the
data out using X categories I cannot understand and not showing the
data grouped by week for comparison.

Any ideas what I can do?

 

[Jon Peltier]

Not knowing the structure of your data (you could paste some as text
into your next post), I'd suggest selecting a blank cell before running
the chart wizard. On step 2, click on the Series tab, click Add, then
select the ranges for series name, values, and category labels. Repeat
with Add for any additional series.

- Jon