Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Scale while creating chart (Excel 2000)

    I am creating a chart based on hours to complete a task. I would like the chart to show days instead of hours. Right now I have to copy the spreadsheet and divide each cell by 8 to convert from hours to days. Is there a way that I can have the "divide by 8" factor a part of my chart? Thanks in advance:-)

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Scale while creating chart (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Dan

    Sorry if this sounds silly, but I am asking to get clarifications...

    Do you enter the data in hours, or days? If hours, then why not enter days?

    If in hours, you could have a mirror-range, a range that is just the same size and shape, with a formula that divides by 8. Then chart based on that range.

    Anything you enter in the main range will be divided into 8 in the mirror range and since the chart is based on the mirror, you get your days.

    Hope this helps.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    Wassim,

    Thanks for your reply.

    I usually use the data in hours, and I get all data in hours, so I enter it that way. But occasionally, I want to report days instead of hours.

    How do I develop a mirror-range? That sounds like what I need. Would the mirror-range update as I add or change data in the Hours sheet?

    Appreciate your response.

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Scale while creating chart (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Dan

    OK I have attached a workbook example for you.

    How to make a mirror range is the name of the workbook, and check the formulas so that you can understand the mirror system. Each cell will have a cell in the mirror range.

    And yes the range will update automatically if Calculations is set to automatic under Tools | Options | Calculations Tab.

    Hope this gives you a starting point.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    Assume that the times are in column C, and that row 1 is a header row. Therefore the first time is in C2. Select an empty column and enter the formula below in row 2 of that column:

    <pre>=IF(C2="","",C2/8)
    </pre>


    Copy that formula down as far as is necessary. Use this column to do your plot.

    If you have empty cells in the time column and don't want those plotted as zero values, then modify the formula to:

    <pre>=IF(C2="",NA(),C2/8)
    </pre>

    Legare Coleman

  6. #6
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    Wassim,

    Thanks a lot. I see what you have done. I think that I will try to have the mirror range as a different worksheet.

  7. #7
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    Legare,

    I appreciate your response. I see how flexible this mirror range can be :-)

  8. #8
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    The attached is a variation on Wassim's mirror technique... I've added a drop down to allow you to switch between Hours/Days. Point your chart at Wassim's suggested mirror range and when you change between hours and days, your chart will automatically update.

    Regards
    Peter

  9. #9
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Scale while creating chart (Excel 2000)

    Peter,

    Thanks so much for your refinement of the mirror technique. That is really slick :-) Works like a charm!!

Posting Permissions

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