Combination Chart

[ea223]

Hi,
I need to make a combination chart which is a bar chart and a line graph. so i want it to show Year1 as a bar chart and then the months as a line graph in between and then year 2 at the end as another bar.
How do I do this?
Thanks

[jeffreybrown]

I'm not quite understanding your acquirement as it seems to the year would be a line across the bars which represent the months.

If you right click on a series you can choose to change the chart type. Select a line or column.

If this does not work for you then maybe post your data with some directions as to what you want to see. I imagine you may have two charts and you want them to be incorporated as one.

http://spreadsheetpage.com/index.php...nation_charts/
http://www.andypope.info/charts.htm
http://peltiertech.com/WordPress/bui...ination-chart/

[ea223]

hi,
thanks. here is an example attached. i want a graph that will show the % of dark for each full year and then month. i would like the years to be bars and the months to be a line graph in the middle...so eventually i will have something like 2011 (bar), 2012 (bar), 2013 (bar) jan 14, feb 14, march 14 etc etc (line) and then 2014 (bar)
does this make sense?!
thank you

[jeffreybrown]

I guess it sort of makes sense, but I have no idea how to get there. Let me ping some others to see if there are other ideas.

[ea223]

thank you!!

[Steve N.]

See if this is what you're looking for.

I took the liberty of moving your month cells up one row so I could use a formula below them to return a date format that I think cleans up these kinds of charts a bit.

If I'm off track - hit me back and I'll give it another go...

[ea223]

Hey, ok thank you this is great, I just need the months to be a line chart and the years to be bars! is this possible? thank you

[Steve N.]

Oops, forgot that part. I'll get back to ya...

[Steve N.]

OK, here's a layered version of what you've described. It's actually two charts 'grouped' with one placed directly over the other. Will that work for you?