+ Reply to Thread
Results 1 to 11 of 11

Building Multiple Axes in chart

  1. 09-23-2012, 03:17 AM #1
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Building Multiple Axes in chart

    Hi,

    I need the support on the following.

    I have build up a line chart with 3 KPI's for 4 region for a period of 12 months. I have been able to show the same through the line chart but problem I am facing is that the figures are so close to each other that the lines are over crossing each other and if I show data values it gets really difficult to determine any analysis out of it.

    I would like to build seperate axes for each KPI (FA,RF and IR) within the chart so that the trend across 4 region (North,south,east, west) get easily visible seperately. I have attached the sample built file for your reference.

    Look forward to your assistance..

    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-23-2012, 06:55 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,448

    Re: Building Multiple Axes in chart

    You could adjust the existing scale to get a widre spread, 30 - 100.

    Or use vertical panel
    http://peltiertech.com/Excel/ChartsH...venScales.html
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 09-23-2012, 07:32 AM #3
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Building Multiple Axes in chart

    Thanks Andy,

    Link you provided is actually what I was looking for as a solution to my concern. I did gave a try to build the vertical panel charts with seperate axis for my data before uploading it to forum but could not succeed. If you could help me build the same for my data or provide me the excel for the peltiertech vertical panel chart solution, it would be really great..!!

    You guys have really rocked and I know you will consider my concern..

    Thanks
    Reply With QuoteRegister To Reply
  4. 09-24-2012, 04:00 AM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,448

    Re: Building Multiple Axes in chart

    That's a pretty comprehensive article, not sure what I can add to it.

    What part of it did you not understand?
    Reply With QuoteRegister To Reply
  5. 09-24-2012, 11:32 AM #5
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Building Multiple Axes in chart

    I have attached the incomplete file for your reference..I am unable to proceed further on this...help me build the final vertical panel chart for me...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 09-24-2012, 11:44 AM #6
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,448

    Re: Building Multiple Axes in chart

    Why are you unable to proceed? At what point of the article do you get stuck.

    From what I can see you have the panels and lines you only need to add the series in order to create the labeling for the panels.
    Reply With QuoteRegister To Reply
  7. 09-24-2012, 11:48 AM #7
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Building Multiple Axes in chart

    that's what..I am unable to add the series and labeling.. not getting it correct..tried few times....
    Reply With QuoteRegister To Reply
  8. 09-24-2012, 12:03 PM #8
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,448

    Re: Building Multiple Axes in chart

    I have added 3 series to the chart and changed them to xy-scatter, as per the instructions.

    All you need do now is apply data labels and link to cell text, as per the instructions.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 09-24-2012, 12:19 PM #9
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Building Multiple Axes in chart

    Thanks Andy,

    It did worked for me. I have progressed on the same. Worked out file is attached.

    I want to show actual values of KPI's (FA,IR & RF) on the 3 lines build and not the plotted values to make the chart more relevant.

    How can this be achieved??

    Regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 09-25-2012, 03:56 AM #10
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,448

    Re: Building Multiple Axes in chart

    Again, you need to read the instructions in the article.

    Finally it's time to add value labels to the vertical axes. You could add labels to each axis series, then manually change the text of each label, but after about the third label this becomes tiresome. Fortunately there are two well-written, easy to install and use, and free utilities that automate this process: Rob Bovey's Chart Labeler, at http://appspro.com, and John Walkenbach's Chart Tools, at http://j-walk.com. Each one allows you to assign the labels in a worksheet range to the points in a chart series, and even link the chart labels, in case the worksheet cells change. Use one of these utilities to assign the three columns of labels (the purple range, columns K through M) to the three axis series (A-axis, B-axis, and C-axis)
    .

    The same technique can be used to label the actual lines with their original values.

    As you seem to find the process difficult to replicate you may find it easier to use 3 separate charts and just lay them out to appear like a single chart.
    Reply With QuoteRegister To Reply
  11. 09-25-2012, 11:50 AM #11
    itsmesunilb
    itsmesunilb is offline
    Registered User
    Join Date
    03-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Building Multiple Axes in chart

    Thanks andy for your support..!! finally, i did it..relief..!! The thread stands closed as of now.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1