If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a floating bar graph with min and max (price for example)
How to I create a graph with floating bars showing price on the y axis so
that I can set a custom min/max for each category. For example I want to compare the min/max price range for a variety of things - each is going to have a different min and max, but all are in the same basic range. I can add a line through the middle that shows average for all things within the category. There is a floating bar graph in my version of PPT, but they are horizontal and I want them to be vertical. - How? |
#2
|
|||
|
|||
create a floating bar graph with min and max (price for example)
EXCEL 2007
I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 105. (I had to click on the tabs to get the Chart to appear; I don't know why). This seems to give you what you want although you will have to adapt it to your needs. I realize you are working in PP. You can either create a link in PP to EXCEL or, once you have completed the work in EXCEL, just paste across a copy of the Chart; whichever suits your needs best. If my comments have helped please hit Yes. Thanks. "Help with graphs" wrote: How to I create a graph with floating bars showing price on the y axis so that I can set a custom min/max for each category. For example I want to compare the min/max price range for a variety of things - each is going to have a different min and max, but all are in the same basic range. I can add a line through the middle that shows average for all things within the category. There is a floating bar graph in my version of PPT, but they are horizontal and I want them to be vertical. - How? |
#3
|
|||
|
|||
create a floating bar graph with min and max (price for example)
If you want the floating Bar Chart version in PPT custom types to show
vertical just change the chart type to a Stacked Column with 3D effects. Hope this helps. Fritz "Help with graphs" wrote: How to I create a graph with floating bars showing price on the y axis so that I can set a custom min/max for each category. For example I want to compare the min/max price range for a variety of things - each is going to have a different min and max, but all are in the same basic range. I can add a line through the middle that shows average for all things within the category. There is a floating bar graph in my version of PPT, but they are horizontal and I want them to be vertical. - How? |
Thread Tools | |
Display Modes | |
|
|