How do I graph data values in every second column

[pphil]

I have a worksheet that has columns as Months and rows that contain data values. Is it possible to graph the data on every second column in a row? i.e A1, A3, A5 etc.

 

[Hui]

Pphil

Select the entire area containing the data

Use the chart wizard to setup your chart

Change Rows<->Columns

Scroll through the data with the arrow keys and delete every series with no data,

toggle back to Rows<->Columns if you can't select a series with no data and try again

If you want Months along the X-Axis change Rows<->Columns until the graph is correct

If you want the Series as groups on the X-axis use the Rows<->Columns until the graph is correct

 

[pphil]

Thanks Hui