Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have three series that I am plotting against categories.
They are a base value and a delta, and a marker series. By stacking them and hiding the base I get a floating bar showing the size of the delta for each category. By showing the marker series as a linechart with markers only I get a symbol showing where this value fits in the range. Ideally I would like a bar chart, categories on the vertical axis, and values from 0 to 100% on the horizontal axis, with very narrow bars - thinner than what I can get with 500% gapwidth. To get that I am plotting to give a floating column chart and pasting that sideways to Powerpoint. Convoluted, yes, but AFAIK I need to use a stacked column chart to get floating bars with one series as markers. At the moment it gives me fairly thick lines for the bars by setting ..gapwidth to 500%. Is there a better way? Thanks! Patrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I get multiple stacked bars per entry on a stacked bar chart? | Excel Discussion (Misc queries) | |||
Stacked bars in a gnatt chart | Excel Discussion (Misc queries) | |||
How do I set up a chart in Excel with lines and stacked bars? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel |