Combine Clustered Columns with Clustered Lines

D

Dom

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/Charts/ClusterColAndLine.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
 

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

Clustered and Stacked Column Chart 1
Countifs or a pivot 1
Stacked Clustered Column? 1
Clustered-Stacked-Column Combo Chart With Lines 2
Clustered Column Chart Containing Stacked Data 1
How do I combine stacked and clustered chart types? 2
Clustered Stacked Chart 1
Date Format + Graph 2

Top