Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I make a vertical floating bar chart?

I want to make a floating bar chart in Excel, but I want the bars to be
orientated vertically rather than the horizontal default. In other words, I
want the range of the floating bars to be displayed on the y-axis rather than
the x-axis. Can anyone help me?

Shane Stamschror
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I make a vertical floating bar chart?

Hi,

You need to use a stacked column chart with 2 series.
The first series provides the 'float'. Format this series to have no fill or
border.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"danke_shane" wrote in message
...
I want to make a floating bar chart in Excel, but I want the bars to be
orientated vertically rather than the horizontal default. In other words,
I
want the range of the floating bars to be displayed on the y-axis rather
than
the x-axis. Can anyone help me?

Shane Stamschror


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Floating bar chart - How? Tec92407 Charts and Charting in Excel 3 October 31st 06 07:03 PM
Floating Bar Chart Andy the Yeti Charts and Charting in Excel 2 October 9th 06 10:32 AM
The vertical title on every chart I make is cut off. nukervilletrolle Charts and Charting in Excel 1 September 30th 06 04:11 PM
Vertical line in a histogram (vertical bar chart) AdamCPTD Excel Discussion (Misc queries) 0 July 13th 06 09:43 PM
Can I make a chart that is vertical instead of horizontal? Karvis Charts and Charting in Excel 2 February 2nd 06 06:12 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"