Struggling to add a secondary axis

**johnstan** · 10-30-2014, 10:36 AM

Hi Guys
I am using 2010 and have a bar chart that shows twelve monthly data values with a YTD value at the end.
I would like to add the YTD as a secondary axis but with the position of the data it currently compresses the rest of the sheet.
I wish to keep the data table as in the chart 1 sheet.
I have spent a lot of frustrating time on this... do I need a Macro?

I have attached a sample sheet with data. The data is on sheet 1.

Any help you can give me with this would be greatly received.

Regards
John

**Jon_Peltier** · 10-31-2014, 03:48 PM

Plot the Monthly and YTD data in a chart.

Select the YTD data on the chart. Press Ctrl+1 (numeral one) to format the series, and select Secondary Axis.

**popipipo** · 10-31-2014, 06:53 PM

I think you need 2 charts
One for the 12 month and one for the YTD values

**johnstan** · 11-20-2015, 09:31 AM

Sorry guys I have been laid up with a long term illness.
This issue is now sored

Struggling to add a secondary axis

LinkBack

Thread Tools

Rate This Thread

Display

Struggling to add a secondary axis

Re: Struggling to add a secondary axis

Re: Struggling to add a secondary axis

Re: Struggling to add a secondary axis

Thread Information

Users Browsing this Thread

Similar Threads

Adding Secondary axis with same scale as Primary axis with for three series

Graph format: primary and secondary axis not congruent for the x axis

Multi-Axis Graph – Setting series colours based on a formula for secondary axis

Line up secondary vertical axis with the primary horizontal axis

[SOLVED] Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis

Bookmarks

Bookmarks

Posting Permissions