+ Reply to Thread
Results 1 to 2 of 2

Can I make the data ranges displayed in a chart vary depending on my no. of data points

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    Manchester, England
    MS-Off Ver
    2007
    Posts
    3

    Can I make the data ranges displayed in a chart vary depending on my no. of data points

    Hi

    I have set up a spreadsheet to record the length of time that people take to complete their competition rounds at my golf club. I use a simply bar chart to show the round time on the vertical axis against the start time on the horizontal axis.

    Start times are spaced at regular 8 minute intervals but the number of start times can vary from one competition to another. For example one competition may run from 8am to 1pm, another from 9am to 3pm. It is easy enough to "parameterise" the actual table of results to show only the start times used on the day but I am struggling to automate my chart so that it displays data points ONLY for the times included in each competition. For example if my first competition contains 10 start times then if the next one includes 20 I have to go into the chart settings and extend the data ranges if the next one has 15 data points then I have to go in and restrict the ranges.

    I have tried using the INDIRECT function to specify the data ranges in the chart settings but that doesn't seem to work.

    It sounds like such an obvious thing to want to do in all types of scenarios - am I missing something.

    Cheers.

    Dave.

  2. #2
    Registered User
    Join Date
    09-04-2014
    Location
    Manchester, England
    MS-Off Ver
    2007
    Posts
    3

    Re: Can I make the data ranges displayed in a chart vary depending on my no. of data point

    I found an excellent article called Dynamic Charts that showed me exactly how to do this. http://peltiertech.com/WordPress/dynamic-charts/

+ 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] VBA to create a chart when data can vary in column position and rows
    By MalibuLX3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-21-2013, 11:21 AM
  2. Replies: 1
    Last Post: 08-11-2012, 05:43 PM
  3. Replies: 0
    Last Post: 07-02-2012, 01:45 PM
  4. [SOLVED] How do you make the Range vary depending on the data?
    By Durlov in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 08:41 AM
  5. Replies: 0
    Last Post: 04-01-2009, 10:54 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