Charting Ranges

[Joyce]

I have some ranges I want to chart - There are only six
values - They consist low ranges high ranges. The raw
data is as follows:

Room Temperature 1:
Low Range: 32
High Range: 256

Room Temperature 2:
Low Range: 2
High Range: 64

Room Temperature 3:
Low Range: 0
High Range: 2

How can I chart this on one chart - I want the scale to
be from 0 - 256 and just have 3 bars to show the
different ranges. Every time I try to chart it using
different charts, the lower values don't show much of a
bar because the Room temperature 1 range is so high. How
would I arrange this data? What chart should I use?

Thank you

 

[Jon Peltier]

Hi Joyce -

Even if you made your scale 0 - 64, the values for RT 3 will be very small. If you
only have three pairs of data, do you really need a chart? Make a nice table:

Low High
Room Temperature 1 32 256
Room Temperature 2 2 64
Room Temperature 3 0 0

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______