+ Reply to Thread
Results 1 to 6 of 6

Dynamic x axis and legend

  1. #1
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Dynamic x axis and legend

    Hi All,

    I used this forum to help me create a dynamic area chart (thank you again to Sktneer for solving my initial problem), I am not trying to make the x axis dynamic, such that the months which do no have data in are not shown.
    I am trying to avoid removing the months which do not currently have data, because the dates represent a fixed contract length.
    I've attached an example file to further illustrate my point.
    I am also trying to adapt the legend on the chart so that only the grades that are currently selected show on the graph?

    Any/all advice would be welcome.
    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Dynamic x axis and legend

    As I said in your previous thread that I don't deal with charts normally, but please find the attached workbook and see if this is what you are trying to achieve.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Dynamic x axis and legend

    Many thanks for this Sktneer, I am trying to achieve this with a checkbox chart rather than with option boxes, will it work in the same way?

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Dynamic x axis and legend

    Okay here is my last attempt.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Dynamic x axis and legend

    Thanks for all of your help Sktneer, much appreciated.

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Dynamic x axis and legend

    You're welcome.

+ 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] Graph legend and axis questions
    By IronCladRooster in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-22-2014, 03:44 PM
  2. Help with Legend on X Axis
    By zwheeler in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2014, 01:27 PM
  3. [SOLVED] Axis & Legend Labels Missing when viewing from Excel 2010
    By Luisao82 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-10-2014, 04:49 AM
  4. Dynamic LEGEND in a Dynamic Chart
    By rekussu in forum Excel General
    Replies: 2
    Last Post: 07-20-2012, 06:03 AM
  5. Legend Only Shows Used Axis on Dynamic Chart (X, Y and Y2 axis)
    By TEBrown in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-21-2012, 10:15 AM
  6. [SOLVED] switch around info from legend to axis
    By Sallie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2006, 10:10 PM
  7. Labelling bar graph-the bars in X-axis not via tthe legend
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-03-2006, 06:30 PM

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