• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

column chart w/ 2 axes

M

mwilliams

New Member
Is there a way to create a column chart in excel with 2 axes? I have my data by month but also need to have YTD data at the end. The value of the YTD data will be much larger than my monthly data. I do not want to have to have a huge scale to accomodate the YTD data, thus wanting to use 2 axes. Thank you in advance!
 
Right click on the Data Column you want on the second axis

Format Data Series

Plot Series on Primary or Secondary Axis
 
That works if you want to put one series of data on the secondary axis. I would like to put 3 series of data but for only one time period on the secondary axis. Any way to do that?
 
You can't move just one point of a series to the secondary axis.

Maybe you could make a separate chart for the YTD values?
 
You can setup a Temporary Chart data area with labels of say

Jan - Dec and then with 2005, 2006, 2007, 2008, 2009 & 2010 in adjacent columns

Just populate the columns from different data sources and chart as normal

Use a secondary axis for the YTD data

I hope that is what your after
 
You must log in or register to reply here.
Back
Top