Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

create a floating bar graph with min and max (price for example)

196 views
Skip to first unread message

with graphs@discussions.microsoft.com Help with graphs

unread,
May 12, 2010, 12:26:01 PM5/12/10
to
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?


trip_to_tokyo

unread,
May 12, 2010, 12:49:01 PM5/12/10
to
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.

fritz78

unread,
May 12, 2010, 4:51:01 PM5/12/10
to
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

0 new messages