ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combine Clustered Columns with Clustered Lines (https://www.excelbanter.com/excel-discussion-misc-queries/193098-combine-clustered-columns-clustered-lines.html)

Dom

Combine Clustered Columns with Clustered Lines
 
I am attempting to create a chart combining clustered column and clustered
lines but I am struggling to create the x series data the example given on
http://www.peltiertech.com/Excel/Cha...olAndLine.html uses 0.25 but
I can not figure out what to use with my graph. I need 5 lines to link into 5
different bar columns but when trying to figure it out myself when I get to
the end and uncheck both secondary axis tick boxes the labels at the bottom
of the graph change from Jan Feb March April May to Jan-00 Jan-14 Jan-28
Jan-42 Jan -56 and there are no lines or bars on it so I assume I am doing
something wrong. If anyone could help I would be really greatful

Thanks


All times are GMT +1. The time now is 08:24 PM.

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