ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   floating bar chart? (https://www.excelbanter.com/charts-charting-excel/34713-floating-bar-chart.html)

Karol

floating bar chart?
 
how do I create a floating bar chart to display the data bars as columns
instead of rows? selecting the row button does not display the data correctly.

Bernard Liengme

Make a stacked column chart
On chart, double click lower data series; format to have No Pattern and No
Border
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Karol" wrote in message
...
how do I create a floating bar chart to display the data bars as columns
instead of rows? selecting the row button does not display the data
correctly.




Jon Peltier

Here's an illustrated explanation:

http://peltiertech.com/Excel/Charts/...ngColumns.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Bernard Liengme wrote:

Make a stacked column chart
On chart, double click lower data series; format to have No Pattern and No
Border
best wishes


Karol

It looks like this is just what I was looking for. Thanks so much!

"Jon Peltier" wrote:

Here's an illustrated explanation:

http://peltiertech.com/Excel/Charts/...ngColumns.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Bernard Liengme wrote:

Make a stacked column chart
On chart, double click lower data series; format to have No Pattern and No
Border
best wishes




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com