Chart Data Ranges

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I posted this in the "Charting Ranges" below.
I'll explain it another way. Sorry someone at work wants
this and I didn't understand the way they wanted it
displayed the first time. Hope I can explain a way
someone understands. I need help!

I have a series of 3 ranges I have to chart
Series 1 ranges from 32 - 256
Series 2 ranges from 2 - 64
Series 3 ranges from 0 - 2

I want it to show 3 bars.
The scale should be 0 - 300
Series 1 should display on the scale from 32 to 256 and
so on with the next 2 series.
How should I set up this data?
 
Set up your data like this:

A B C D
Low Range High
Room1 32 =D2-B2 256
Room2 2 64
Room3 0 2

Copy the formula down to row 4
Select cells A1:C4
Click the Chart Wizard button
Select the Bar chart type, and the Stacked Bar subtype
Continue through the Chart Wizard, selecting the options you want
Select the chart
Right-click on the Low data series
Choose Format Data Series
 
Thank you so much - You're da bomb!
-----Original Message-----
Set up your data like this:

A B C D
Low Range High
Room1 32 =D2-B2 256
Room2 2 64
Room3 0 2

Copy the formula down to row 4
Select cells A1:C4
Click the Chart Wizard button
Select the Bar chart type, and the Stacked Bar subtype
Continue through the Chart Wizard, selecting the options you want
Select the chart
Right-click on the Low data series
Choose Format Data Series



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top