+ Reply to Thread
Results 1 to 4 of 4

How to make three axis in one line chart

  1. #1
    Registered User
    Join Date
    07-04-2023
    Location
    London
    MS-Off Ver
    2019
    Posts
    2

    How to make three axis in one line chart

    Hello everyone, i need help pls!
    I've made a line chart with three lines and data from three years but at the
    bottom, in the axis i can select only one year.
    My question is how should i do in order to have three axis and keep same format of the chart?
    Last edited by ranger1719; 07-04-2023 at 02:20 AM.

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

    Re: How to make three axis in one line chart

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


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

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-04-2023
    Location
    London
    MS-Off Ver
    2019
    Posts
    2

    Re: How to make three axis in one line chart

    my apologies, i've attached the workbook

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

    Re: How to make three axis in one line chart

    Assuming I understand what you want the end result to be, I would suggest this essay as a starting place: https://peltiertech.com/good-chart-data/

    The key thing to note from this is that it is often valuable to have separate tables for the user to look at and for the chart to look at. The table for the chart will be easiest to work with if it includes:

    1) A date column in the left column. I understand that you want to chart the data across month and day and ignore year. In that case, I would probably choose a leap year (2020, maybe) for this column, so that you have fewer issues handling 29 Feb.
    2) Each Y column will represent a year. A lookup type of function can be used to query the data base in each column from the data for the corresponding year.
    3) Once you have a single x column with multiple y columns, you can select this table and insert the desired line chart. Format chart elements as desired.

    Details of that process will depend on where the raw data are being stored and the overall design of that database.

    In the event that this is the raw data, it will be easy enough to work with this data as is. Since this appears to be intended to be a growing database, I might suggest that some thought be put into good database design. What you have now is not a very good design for a database. In the short term, it makes little difference while the database is small. As the database grows, though, good database design now will make it easier to update and maintain the database and retrieve and summarize data later on.
    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: 9
    Last Post: 07-12-2016, 12:30 AM
  2. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  3. How do I make a line-column 2-axis chart in Excel 2007?
    By shadestreet in forum Excel General
    Replies: 2
    Last Post: 04-09-2009, 09:35 PM
  4. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM
  5. Replies: 2
    Last Post: 09-22-2005, 06:57 AM
  6. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  7. make line in chart start at y axis
    By Tone in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2005, 05: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