+ Reply to Thread
Results 1 to 4 of 4

Chart for more values on X axes

  1. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Leeds
    MS-Off Ver
    Microsoft Office 365
    Posts
    271

    Chart for more values on X axes

    Good afternoon,

    My this question is an extension of my previous thread I posted yesterday.

    Most of my analysis involves the data as shown in the attached file. I never managed to get this type of graph in Excel as there are more than 10000 rows ( for 4 ccgs that I want to analyse the data).

    For example, this graph is just for organisation A not in Excel but from the system we use to fetch the data. I can't use that graph as it becomes static (Like a picture) once exported from that system. Where we are reviewing categories ( shown on X-axis in the attached file) the items on the X-axis with the value >150,000. How can we compare 4 organisations on the same chart?

    I am grateful for the help I get here. Would you please help with some example file so that I can follow and recreate that for my requirement.

    Thank you.
    Attached Images Attached Images
    Last edited by Jigneshbharati; 08-03-2021 at 07:56 AM. Reason: complete information and context

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,564

    Re: Chart for more values on X axes

    Most of my analysis involves the data as shown in the attached file.
    This statement indicates that there should be a file attached, which there isn't as far as I can tell.
    Instructions for attaching an Excel file are given in the banner titled: HOW TO ATTACH YOUR SAMPLE WORKBOOK
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Leeds
    MS-Off Ver
    Microsoft Office 365
    Posts
    271

    Re: Chart for more values on X axes

    Thank you for your help. I solved the problem and I am so sorry that I didn't attach the file.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,564

    Re: Chart for more values on X axes

    Glad that you solved the problem. Thank You for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. [SOLVED] Ignoring chart types with no axes for finding axes title
    By gregersdk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2017, 06:41 AM
  2. Custom number format code for hiding specific values on chart axes
    By rob_storrar in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2012, 12:27 AM
  3. Replies: 1
    Last Post: 06-09-2011, 03:44 AM
  4. Merging code for hiding columns and setting chart axes values
    By tuckjoseph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2010, 01:19 PM
  5. [SOLVED] Is it possible to add more than 2 x-axes to a chart?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2006, 06:55 AM
  6. XY-Chart with 4 axes
    By monir in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-03-2005, 06:00 PM
  7. [SOLVED] Create Custom Chart with 2 Axes Values in VBA
    By wira in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2005, 12:05 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