+ Reply to Thread
Results 1 to 4 of 4

Data attaches to wrong Axis Label

  1. #1
    Registered User
    Join Date
    09-03-2021
    Location
    Scotland
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    2

    Post Data attaches to wrong Axis Label

    Hi, Im not the best at formatting graphs when excel interprets the information differently from how I'd like. I've attached a excell sheet, its basically to track finances, Im trying to use a graph to visualise the data but for some reason the data for 2021 appears on the 2022 axis label and vise versa. Any tips?
    Attached Files Attached Files
    Last edited by Scotthc; 09-05-2021 at 07:48 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Data attaches to wrong Axis Label

    To which charts are you referring?
    I'm assuming the two charts on the Income sheet, but both show the correct data as far as I can see.
    Admittedly you've used B4:B15 for the y axis on the 2022 chart rather than B19:B30 but given the values are the same it makes no difference.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

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

    Re: Data attaches to wrong Axis Label

    For the category labels you had =(Income!$A$19,Income!$A$4)

    instead of =(Income!$A$4,Income!$A$19)
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    09-03-2021
    Location
    Scotland
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    2

    Re: Data attaches to wrong Axis Label

    Thanks Andy, that fixed my problem

+ 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. Remove one label from Multi-label axis in a Pivot Chart
    By Mile029 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-25-2021, 04:53 PM
  2. Help with getting set variables in x axis and names as a data label
    By OhYouDidntKnow in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-13-2021, 04:03 AM
  3. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  4. Select x-axis label source for a large label range
    By Ernst100 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-03-2019, 10:52 AM
  5. [SOLVED] X-axis of scatter chart: Tick mark and X-axis label for every data point
    By JayUSA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2018, 02:38 PM
  6. Help: substitute x-axis label with data from different column
    By atung in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-24-2014, 06:35 AM
  7. Excel 2007 : Horizontal Axis Label - Last Data Point
    By bignowa in forum Excel General
    Replies: 1
    Last Post: 07-02-2010, 09:53 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