+ Reply to Thread
Results 1 to 5 of 5

Two same Y axis on single charts

  1. #1
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    MS Office 365
    Posts
    38

    Exclamation Two same Y axis on single charts

    Hello,
    Please see attached excel sheet.
    I am trying to create a single chart with two same Y axis. (Sample is attached in excel sheet).

    Your help is appreciated.
    Thank you.
    Attached Files Attached Files

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

    Re: Two same Y axis on single charts

    I wasn't certain what all was essential in the desired final, so I'm not sure if this helps. Looking at what you have and what you want, it looked to me like it was essentially a "date in row or column" problem. I pulled up the Select Data dialog, executed "switch row/column", then edited the horizontal category axis labels to be C2:D2. That came pretty close to the "need result" picture. What are the essential parts/formats in your desired chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    MS Office 365
    Posts
    38

    Re: Two same Y axis on single charts

    @MrShorty,
    Thank You for your reply.
    I already tried to switch row/column, but it doesn't give me the result I want.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,352

    Re: Two same Y axis on single charts

    Can you be more specific? What about the chart is not correct? Is there anything about the chart that is correct?

    FWIW, this is what I get after the two steps I mentioned. It looks almost exactly like your desired chart, except for column color and axis labels.
    Attached Images Attached Images

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,102

    Re: Two same Y axis on single charts

    You can reconfigure you data layout to get the chart required
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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: 2
    Last Post: 01-22-2015, 03:51 PM
  2. Charts: Format Axis -> Axis Options -> Fixed minimum and maximum
    By johnmata in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-28-2013, 05:53 PM
  3. Charts: Format Axis to Text Axis in VBA?
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 05:49 AM
  4. Replies: 0
    Last Post: 12-08-2007, 06:14 PM
  5. dot plot - single x axis location with multiple y axis dots
    By EJF in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-22-2006, 10:15 PM
  6. select & format "single" axis line in charts
    By Guru Guy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2006, 11:40 PM
  7. [SOLVED] Hiding Values Below Z Axis Minimum Value on Axis Charts
    By TryingToExcel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 11:06 AM

Tags for this Thread

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