Charting a DATE range - chart reverses.

[MarkBeck]

Hi

I have a date range in column A, and corresponding values in B. I have a BAR chart running vertically parallel to the data, charting negative and positive values.

Dates are ascending, at 7 days apart.

The Chart horizontal gridlines are the same size as the spreadsheet row height, thus should theoretically display its bars parallel to the worksheet data. For some reason the chart starts from the BOTTOM.

What can i do to reverse the chart order?

Mark

 

[SkipVought]

Hi,

Activate the chart.

Select the axis where the data is inverted (Category)

Select the Scale tab

Check Categories in reverse order

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[SkipVought]

...AND, since you have the category axis in reverse order, you should also change the Category(x) Axis in Chart Options from Auomatic to Category. Otherwise it will treat your DATES on the axis relative to Date/Time, rather than discrete occurrences.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[MarkBeck]

Thank a lot Skip. Bulls-eye as usual.