Thread: Need help with formatting

Hi,

I have a series of data that has a header row of non-consecutive number for example:

1,3,4,6,8,9,11,13,14,15
Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data

When I try to create a chart, the non-consecutive numbers that should apper on the x-axis appear as consecutiver (ex: 1,2,3,4,5,6,7,8,9,10,11...)
How do make it so that the non-consecutive numbers appear?

Thanks in advance for any help,

Calli

Turn those non-consecutive numbers to text strings by adding an apostrophe in front of each.

Originally Posted by calli

Hi,

I have a series of data that has a header row of non-consecutive number for example:

1,3,4,6,8,9,11,13,14,15
Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data,Data

When I try to create a chart, the non-consecutive numbers that should apper on the x-axis appear as consecutiver (ex: 1,2,3,4,5,6,7,8,9,10,11...)
How do make it so that the non-consecutive numbers appear?

Thanks in advance for any help,

Calli

Select your data row and create your chart, select the bar chart - Next, select the Series tab, and at the bottom select the Category (x) Axis labels, set this to your header row.

hth
---