How do I make a vertical floating bar chart?

G

Guest

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked column chart narrow bars wanted 5
floating bar type chart 4
Odd chart type needed 2
add vertical line to floating bar chart 2
Floating bars 2
add vertical line to floating bar chart, still trying 6
Creating a Combination Bar Chart with 2 Lines 1
reference line on bar chart 2

Top