Line/Bar combo chart: issues
If anyone can hepk me out with this:
I have 4 series of data that I'm trying to graph, 3 series as a bar graph and one as a line, on the same chart. The custom bar-lin chart automatically splits the series into pairs (i.e. it graphs 2 series as bar graphs and the other 2 series as lines). How do i change this so that i can have 3 bars/1 line? marty |
Line/Bar combo chart: issues
Hi,
Ignore the built-in combination types and instead roll your own. Create a column chart based on all 4 data series. Select the series to be plotted as line chart. Right click and choose Chart Type. Select Line Chart. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "martinbarnes" wrote in message ... If anyone can hepk me out with this: I have 4 series of data that I'm trying to graph, 3 series as a bar graph and one as a line, on the same chart. The custom bar-lin chart automatically splits the series into pairs (i.e. it graphs 2 series as bar graphs and the other 2 series as lines). How do i change this so that i can have 3 bars/1 line? marty |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com