Results 1 to 6 of 6

Dynamic x axis and legend

Threaded View

  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

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