Results 1 to 3 of 3

Thread: Question about data ranges

  1. #1

    Question about data ranges



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a sheet that has static data in row1 and column 1. They are times across the top and dates down the side. Then starting at cell A2 my data begins. I have made a simple bar chart that charts my data for me. The problem I'm having is that I have a macro on a home tab that inserts a new row at the top of my data and shifts everything down. I'm looking at the newest data (8 rows worth) but when I insert a new row, the chart's data range shifts down as well. How can I prevent it from shifting the range ? I am completely stumped. Here is a sample of my data. When I chart it I get the times across the bottom, multiple bars in each time field, and then the series labeled on the right side of What color represents each day.

    Day of Week Date 11AM 12PM 1PM 2PM 3PM 4PM 5PM 6PM 7PM 8PM
    Tuesday 5/7/2013 1 2 3 4 0 6 7 8 9 10
    Tuesday 4/30/2013 1 2 3 4 0 6 7 8 9 10
    Tuesday 4/23/2013 1 2 3 4 0 6 7 8 9 10
    Tuesday 4/16/2013 18 10 22 15 11 10 13 20 29 12
    Tuesday 4/9/2013 0 0 0 0 0 0 0 0 0 0
    Tuesday 4/2/2013 0 0 0 0 0 0 0 0 0 0
    Tuesday 3/26/2013 0 0 0 0 0 0 0 0 0 0
    Tuesday 3/19/2013 0 0 0 0 0 0 0 0 0 0

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    You can set up a dynamic range that adjusts to always point to the first 8 rows. Do you still need help with this?

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Depending on your Excel version you might be able to format the data as a Table (or List if prior to Excel 2007)
    Hope that helps

    Roy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •