Excel 2007 Data Bars

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 1 of 1

Thread: Excel 2007 Data Bars

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    North Yorkshire, UK
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel 2007 Data Bars

     
    I'm creating a dashboard report using the new Data Bars options under conditional formatting of Excel 2007.

    I already have one set of data bars created on data that ranges from 2 up to 320.

    I now want to add another set of data bars to a different set of data with a much smaller number range (10 to 55).

    Both data sets will increase week on week, but the maximum number in the second data set will always be about 5 or 6 times less than the maximum value in the first data set.

    Is there any way - using the data bars - to display the length of the bar so that it relates to the length of the bars in the first data set? In other words, a value of 50 in both data sets will have a data bar of the same length?


    UPDATE:
    I've figured out a way to do it by rearranging my data so that I had the figures for both data sets in the same column and just creating a single range with the data bars conditional formating. Simples!
    Last edited by JugglerJAF; Apr 8th, 2010 at 08:11 AM.
    It's curtains for your Dr. Horrible ... lacy, gently wafting curtains.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com