ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Overlapping floating column charts? (https://www.excelbanter.com/charts-charting-excel/264778-overlapping-floating-column-charts.html)

Doug

Overlapping floating column charts?
 
I was reading a post by Jon Peltier on how to overlay a floating column chart
showing open/close data
over a high-low line chart showing high/low data. After creating one with
this data, I cannot figure out how to make them lay overtop of one another?
They are still stacked...
--
Thank you!

Luke M[_4_]

Overlapping floating column charts?
 
Perhaps this?
Format series - options, increase overlap to 100

--
Best Regards,

Luke M
"Doug" wrote in message
...
I was reading a post by Jon Peltier on how to overlay a floating column
chart
showing open/close data
over a high-low line chart showing high/low data. After creating one with
this data, I cannot figure out how to make them lay overtop of one
another?
They are still stacked...
--
Thank you!




bala_vb

Quote:

Originally Posted by Doug (Post 956713)
I was reading a post by Jon Peltier on how to overlay a floating column chart
showing open/close data
over a high-low line chart showing high/low data. After creating one with
this data, I cannot figure out how to make them lay overtop of one another?
They are still stacked...
--
Thank you!


right click on the bar/line in the char, go to series overlap, adjust the figure.

all the best


All times are GMT +1. The time now is 01:29 AM.

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