+ Reply to Thread
Results 1 to 2 of 2

How to make a series that has all of the data on a secondary axis?

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,067

    How to make a series that has all of the data on a secondary axis?

    Hello,

    Say I have the following series, USA, Canada, Europe and Asia.

    And on each series, I have the year 2015 and 2016.

    Due to the big in numbers of one of the series, the other small numbers can't be seen.

    Thus, am wondering is there a way to make a specific series, i.e. Europe and Asia for the data in 2015 and 2016 onto a secondary axis?

    Below are the screenshot of the 'original' and 'desired'

    using big numbers.png
    BEFORE - notice the big numbers, the other's can't be seen.


    Using small numbers.png
    AFTER - I desired that the 'Europe' and 'Asia' to be in a secondary axis so that the big numbers are together and the small numbers are together.
    However, please take note that I cheated when creating this chart with small numbers so as to show what I desire the outcome to be.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,921

    Re: How to make a series that has all of the data on a secondary axis?

    It is not clear to me exactly what you're trying to do.

    If you want some of your data to be on the primary axis system and some of your data to be on the secondary axis system, you will need separate data series for each. If I assume your spreadsheet currently has two columns (one for 2015 and one for 2016), you will need to expand to an additional four columns (2015 primary, 2016 primary, 2015 secondary, 2016 secondary). Populate these four columns with the desired values for each entry, then base your chart on these four columns. Use the format series dialog to transfer the desired data series to the secondary axis system.

    It's a little more complex to build, but a panel chart might be a better overall technique for visualizing data like this: http://peltiertech.com/Excel/Charts/StackedCharts.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-14-2015, 04:21 PM
  2. Replies: 2
    Last Post: 10-08-2014, 08:04 PM
  3. Replies: 1
    Last Post: 10-08-2014, 06:36 PM
  4. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  5. VBA: add a series of data (Y secondary axis) to existing graph
    By sweetboy02125 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-21-2010, 06:34 AM
  6. Replies: 0
    Last Post: 07-14-2006, 09:15 AM
  7. Replies: 2
    Last Post: 08-12-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1