+ Reply to Thread
Results 1 to 2 of 2

Have chart auto change depending on axis labels

  1. #1
    Registered User
    Join Date
    09-11-2015
    Location
    gateshead
    MS-Off Ver
    365
    Posts
    62

    Have chart auto change depending on axis labels

    So on my graph (if the image uploaded)
    I have the label axis with lots of gaps - which are the facilities that have had 0 downtime.
    I've set it up that way.

    However I'm asking: can I have the graph update itself. So if there's nothing as a label, it'll ignore that and pull the graph closer together instead of showing loads of empty space?

    Cheers all!
    Attached Images Attached Images

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

    Re: Have chart auto change depending on axis labels

    Search for dynamic chart series.
    You need to define dynamic named ranges for the values and catergories
    Cheers
    Andy
    www.andypope.info

+ 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. Changing chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  2. Change X-axis labels on pivot chart?
    By Matteo2000 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2014, 04:15 AM
  3. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  4. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  5. Replies: 1
    Last Post: 06-26-2012, 10:02 AM
  6. [SOLVED] In a bar chart, how do I change the x-axis "category" labels?
    By thermactor in forum Excel General
    Replies: 1
    Last Post: 12-02-2005, 03:20 AM
  7. [SOLVED] how to put x axis values in the chart instead of x axis labels
    By Sinclair in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2005, 06:05 AM

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