+ Reply to Thread
Results 1 to 4 of 4

Can I graph 4 separate axis items on ONE chart?

  1. #1
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Can I graph 4 separate axis items on ONE chart?

    Lo All o7 <--- saluting

    I am trying to tie some of our A/R data into a single chart to allow our GMs to visually ID disparities (second image). I have attached the aggregated data and two charts that I am trying to merge into one. The second chart's axis aren't necessary as they're conceptually relative. If I try to overlap the second chart and remove the axis the lines flatten out, when I make the axis text white it can mess up the existing axis labels from the first graph (third image).

    Ideas? Is it possible?

    ExcelGraphMerge.png

    ExcelGraphMerge2.png

    ExcelGraphMerge3.png
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Can I graph 4 separate axis items on ONE chart?

    You can't do it with single chart.

    Likely you will need to set everything but the series set to "No fill" in second chart and superimpose it on top of first.

    Something like attached.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

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

    Re: Can I graph 4 separate axis items on ONE chart?

    I would suggest that you need to think carefully through what you are trying to communicate or visualize here. Built in, Excel can only handle primary and secondary axis systems, and that is probably a good thing. A chart with 4 axis systems would be difficult to read.

    The final picture you show, and CK76's superimposed chart, is difficult to read, because the ARTurn and DSO data series do not have correct axes on the chart. For example, looking at the max point in the DSO series, I have no way of reading from the chart that the value there is about 55. I can only see that it might be about 2500 or it might be about $140000. As CK76 shows, it is certainly possible to superimpose charts on top of charts. At some point, this becomes difficult to read.

    If the superposition is adequate for your needs, then you can ignore this. I might suggest that you consider something like a panel chart. Here is one tutorial that discusses how to build such a chart: https://peltiertech.com/Excel/Charts/StackedCharts.html Beyond that, I have no other suggestions without knowing something more about what you are trying to show with this chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Re: Can I graph 4 separate axis items on ONE chart?

    Quote Originally Posted by MrShorty View Post
    I would suggest that you need to think carefully through what you are trying to communicate or visualize here. Built in, Excel can only handle primary and secondary axis systems, and that is probably a good thing. A chart with 4 axis systems would be difficult to read.

    The final picture you show, and CK76's superimposed chart, is difficult to read, because the ARTurn and DSO data series do not have correct axes on the chart. For example, looking at the max point in the DSO series, I have no way of reading from the chart that the value there is about 55. I can only see that it might be about 2500 or it might be about $140000. As CK76 shows, it is certainly possible to superimpose charts on top of charts. At some point, this becomes difficult to read.

    If the superposition is adequate for your needs, then you can ignore this. I might suggest that you consider something like a panel chart. Here is one tutorial that discusses how to build such a chart: https://peltiertech.com/Excel/Charts/StackedCharts.html Beyond that, I have no other suggestions without knowing something more about what you are trying to show with this chart.
    Indeed, I have been playing with a variety of versions that conveys a general understanding of KPIs. I will def try that panel chart, appreciate the link.

+ 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. Pivot Chart - Display data in X axis (all) items regardless of count
    By gtp2014 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-22-2014, 11:50 AM
  2. [SOLVED] Single axis graph/chart
    By riffology in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-17-2013, 05:53 PM
  3. [SOLVED] Spacing between items onthe horizontal axis in a pivot chart
    By bruinsrme in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-16-2013, 10:39 AM
  4. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  5. Is it possible to Graph Alphanumeric values in an x, y, z, axis chart?
    By aranlane in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2013, 06:48 AM
  6. Graph/chart axis max reference
    By mljs54 in forum Excel General
    Replies: 1
    Last Post: 08-27-2011, 06:07 AM
  7. Replies: 0
    Last Post: 02-11-2005, 11:40 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