Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to decrease tick mark labels in Area/Line combo chart? | Charts and Charting in Excel | |||
how to get zeros to match in line-bar combo chart on 2 axes | Charts and Charting in Excel | |||
Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
How to change a bar to line in a combo chart? | Charts and Charting in Excel | |||
Bar-Line Combo Chart | Charts and Charting in Excel |