Creating bar charts using value ranges for each entry

  • Thread starter Thread starter Claire Hartley
  • Start date Start date
C

Claire Hartley

I want to create a bar / column graph using Microsoft
Graph where each data entry consists of a range of values
(i.e. has a lower and upper value).
For example: I have 3 different products. The price of
each product will vary (have a lower and upper price - a
range). Let's say Product one's price ranges from $75 -
$100, Product two's price ranges from $65 - $120, and
Product three from $60 - $115. I want to show graphically
the three product prices as three blocks/bars next to each
other (for comparison).

Hope you understand what I'm asking here. Please help as
I'm very frustrated!
 
In a column, put the names of the products. So, if you have three
products, you will have three entries in the column. In the next
column, put the lower price for each product. Again, with three
products, you will have three entries in the column. In the next
column, put the *difference* in price between the high and low price
for each product. Again, three entries in the column.

Select the data, click the chart wizard, create a column chart, subtype
Stacked. In step 2 of the wizard, ensure that the 'Data in Columns'
option is selected.

Once done, double-click the lower of the plotted columns, then select
the Patterns tab. Set the border and the area to None.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thank you very much for your help Tushar.
-----Original Message-----
In a column, put the names of the products. So, if you have three
products, you will have three entries in the column. In the next
column, put the lower price for each product. Again, with three
products, you will have three entries in the column. In the next
column, put the *difference* in price between the high and low price
for each product. Again, three entries in the column.

Select the data, click the chart wizard, create a column chart, subtype
Stacked. In step 2 of the wizard, ensure that the 'Data in Columns'
option is selected.

Once done, double-click the lower of the plotted columns, then select
the Patterns tab. Set the border and the area to None.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.
Click to expand...
 
Back
Top