LinkBack URL
About LinkBacks
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
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
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/
Last edited by jeffreybrown; 11-18-2012 at 09:26 PM.
HTH
Regards, Jeff
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
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.
thank you!!
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...
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
Oops, forgot that part. I'll get back to ya...
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks