Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination Line and Bar Graph
I am using a line graph to chart 2 years worth of monthly data (each year a
separate line). I also want to show the YTD totals for both years as a bar graph (i.e. if the current month is August, I want to show the Jan - Aug Year 1 total as one bar graph and the Jan - Aug Year 2 total as another bar graph). I have successfully both type of graphs into one graph chart. However, I want to show the bar graph on the right hand side of the graph. How can I accomplish this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination Line and Bar Graph
Hi,
Try double clicking one of the bar (column) series and on the Axis tab select secondary axis. Select the other bar series and press F4 to repeat the operation. Cheers Andy M Moore wrote: I am using a line graph to chart 2 years worth of monthly data (each year a separate line). I also want to show the YTD totals for both years as a bar graph (i.e. if the current month is August, I want to show the Jan - Aug Year 1 total as one bar graph and the Jan - Aug Year 2 total as another bar graph). I have successfully both type of graphs into one graph chart. However, I want to show the bar graph on the right hand side of the graph. How can I accomplish this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|