One of two series in a line chart is in reverse order and doesn't match axis

John Steel

New member
Joined
Aug 16, 2014
Messages
7
Reaction score
0
Points
0
I have a line chart that plots two series - one for vacancy and one for asking rate. When the chart displays, the vacancy displays as expected - matching the vacancy with the year. But the asking rate is in reverse chronological order (the opposite of how it should be, how the vacancy displays, and the y-axis displayed on the chart). I've included a snapshot of the part of the worksheet below. Basically, I want Series 2 (the red line) to flip horizontally to go in chronological order. By the way - some of the rows in the table above the chart are hidden, but are displayed in the chart below.

Any suggestions on reversing just one series' plot order without changing the other parts of the chart display?

Thanks

excel chart issue.jpg
 

Andy Pope

New member
Joined
Mar 22, 2011
Messages
43
Reaction score
0
Points
0
Location
London, England
Website
www.andypope.info
Excel Version(s)
2016
You need to enable the secondary horizontal axis in order to set categories in reverse, as you have done on primary axis.

You will also need to set Vertcial axis crosses at maximum, which is also on the format dialog for secondary horizontal axis
 

John Steel

New member
Joined
Aug 16, 2014
Messages
7
Reaction score
0
Points
0
Thank you Andy. I thought this thread was long forgotten and had already rigged a fix by transposing my series 2 data in reverse order and pulling the chart data from that. Your advice works and I'll apply it in the future.

Thx again
 
Top