+ Reply to Thread
Results 1 to 6 of 6

Create Multiple Line Charts with different Scales in Excel or Similar Tool?

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    3

    Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    I want to create multiple line charts in one Image, with different scales. Right now, I am achieving this by selecting line plots with desired rows, then selecting one row by one row, taking the screenshot and pasting it in the paint. Final product is like this -


    Kindly let me know what should be an automated and easy way to create this type of charts?
    Attached Images Attached Images
    Last edited by bnbnqwe; 02-11-2022 at 05:15 AM.

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

    Re: Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    You will find plenty of examples on Jon Peltier's page
    https://peltiertech.com/?s=panel+chart
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-13-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    Forum is not allowing me to paste images. If I can show the images, my problem will be clear.

    I want to achieve this -

    jrL8D.png

    The tabular data is -

    iwEXR.png
    Attached Images Attached Images
    Last edited by bnbnqwe; 02-11-2022 at 05:14 AM.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2301 (Windows 11 22H2 64-bit)
    Posts
    65,652

    Re: Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    You can attach images as long as they do not exceed the maximum size allowed, as listed in the Manage Attachments screen. Follow the instructions for attaching a workbook at the top of the page - it's the same process for images.

    There is currently nothing to see in your post.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Registered User
    Join Date
    07-13-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    Thank you for the clear instructions. I have updated the post with relevant images. Kindly help

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

    Re: Create Multiple Line Charts with different Scales in Excel or Similar Tool?

    I'm going to agree with Andy, that what you appear to be describing is a panel chart, and Peltier has several tutorials for creating panel charts. Perhaps this one (written before Excel 2013 came out, so it was written before "data labels using values from cells" was built in to Excel) will help? https://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: 10-16-2014, 02:01 PM
  2. Coding to Create similar charts for Range of coloumns
    By montego in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2010, 01:05 PM
  3. Replies: 1
    Last Post: 06-04-2010, 03:51 AM
  4. Line chart with multiple scales/units along an axis...
    By JohanD in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2006, 01:00 AM
  5. [SOLVED] multiple charts similar size?
    By raoulreulen@hotmail.com in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-10-2006, 01:20 PM
  6. Disappearing scales on bar charts with multiple series
    By Patrick in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-03-2005, 05:15 PM
  7. I want to create 4 pie charts in a line
    By Shweta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-05-2005, 04:05 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