+ Reply to Thread
Results 1 to 2 of 2

Problems with chart with 4 axes?

  1. #1
    Registered User
    Join Date
    10-13-2013
    Location
    California
    MS-Off Ver
    2007
    Posts
    12

    Problems with chart with 4 axes?

    Every time I upload the chart from the attached file, something is missing and I don't know how to format it so that all the different categories reflect what I want it to.

    Forgot to add that all three have to be represented in the same chart.
    Attached Files Attached Files
    Last edited by Ladyrose722; 03-02-2015 at 11:54 PM.

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

    Re: Problems with chart with 4 axes?

    There is no chart in your sample file, and it is difficult to understand exactly what you want to show and what difficulties you are having.

    Multiple axes is always difficult, tends to be difficult to read and understand, and many suggest staying away from multiple axes on one chart.

    Excel has built in support for a primary and a secondary axis system. https://support.office.com/client/Ad...1ec1c8c97#bmxl You can have more axes, but you have to "make" them yourself. As noted, this gets to be difficult to read, and sometimes difficult to maintain.

    Some charting experts suggest staying away from multiple axes. One example here: http://peltiertech.com/Excel/Charts/TertiaryAxis.html You might consider whether a panel chart would be a better choice for the data you need to display.
    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. Multiple Axes Problems
    By derringt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2015, 12:36 PM
  2. Chart with two different y axes
    By n_ant in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-29-2013, 08:22 AM
  3. Problems aligning 2 X axes
    By excalibur313 in forum Excel General
    Replies: 0
    Last Post: 08-04-2011, 01:28 AM
  4. Replies: 1
    Last Post: 06-09-2011, 03:44 AM
  5. [SOLVED] XY-Chart with 4 axes
    By monir in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-03-2005, 06:00 PM

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