Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

Proportional bar width in charts?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter M - 28 Sep 2007 18:15 GMT
I am trying to create a bar chart where the width of the bar is the "X" value
and the height of each bar is the "y" value.

I am trying to create a chart similar to  the Vattenfall CO2 abatement
chart, which I have discoveed cannot be pasted into this posting <sorry about
that>

Thanks for any advice
Del Cotter - 28 Sep 2007 22:34 GMT
>I am trying to create a bar chart where the width of the bar is the "X" value
>and the height of each bar is the "y" value.

You can do it if you make use of the Time-line X-axis in the Area Chart
type. By careful choice of numbers, you can create a rectangular area
that looks exactly like a conventional bar chart, but where the width of
each bar is under your control.

You can also make a stacked area graph look like a stacked bar chart in
the same way, and by eliminating the spaces between the stacked bars,
you can make a Matrix chart.

See this example of mine:

http://www.branta.demon.co.uk/excel/DCVarBar.xls

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.