Date Labels in Chart

[chrome700]

I have a dataset that looks like this:

And have been able to set up the data source like this:

But not matter what I do I can't get the dates to actually appear correctly on the chart:

If I have date selected (as above) it's merely applying date formatting to 1, 2, 3.... and not referencing the column I want.

How do I get the actual text dates referenced in column AU above to me the horizontal labels on the chart?

As much as I love Excel, sometimes it does its best to drive me crazy like this.......

 

[GraH]

Date cannot be a serie, it's only the category of the axis.
Make sure to define it on one of the plotted series.
Most likely you have your first column with the sequence 1 -16 defined as category Axis label.

 

[chrome700]

You can see from the second screenshot that 'Date' is already a defined series, and the H Axis label range is already set as column AU, as displayed on the right side of the same screenshot.

 

[GraH]

It should not be a dataseries.
Are those dates real dates or is it text?
How did you define the axis format?

 

[chrome700]

Ok, I see what you're saying. I misread your earlier post.
Those are real dates, but I could turn them into text easily enough.
Axis format is current General, but only because 'Date' doesn't yield anything useful.

Let me experiment a bit......

 

[chrome700]

Still can't get this to work properly.......

 

[GraH]

Can you try this

Select the ranges AU2:AU18 and AW2:AW18. Press ALT+F1. This inserts a default chart, mine is a column chart.

Then select the other ranges you'd like to plot and copy paste inside the chart.
Finally format each data series accordingly.

 

[chrome700]

Can you try this

Thanks! Did a variation of that (just selected all the relevant data, then clicked 'Recommended Chart' and was able to get what I needed.