A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 05:26 PM posted to microsoft.public.powerpoint
Help with graphs
external usenet poster
 
Posts: 1
Default 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  
Old May 12th, 2010, 05:49 PM posted to microsoft.public.powerpoint
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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  
Old May 12th, 2010, 09:51 PM posted to microsoft.public.powerpoint
fritz78
external usenet poster
 
Posts: 41
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.