Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining different excel charts
Hi, I have an economic time series that I've graphed using a line chart. Our professor wants us to add recessions to this chart. Is there a way adding a bar chart to a line chart? I just drew vertical lines between the dates in question and added diagonals but the graph looks amateurish. Ideally, I'd like to be able to add a shaded column between the dates but still have the line show through the shaded area. Thanks. Bob -- rkizik ------------------------------------------------------------------------ rkizik's Profile: http://www.excelforum.com/member.php...o&userid=35342 View this thread: http://www.excelforum.com/showthread...hreadid=551123 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining different excel charts
Hi,
Have a look at Jon Peltier's example of vertical banding, http://peltiertech.com/Excel/Charts/...ticalBand.html Cheers Andy rkizik wrote: Hi, I have an economic time series that I've graphed using a line chart. Our professor wants us to add recessions to this chart. Is there a way adding a bar chart to a line chart? I just drew vertical lines between the dates in question and added diagonals but the graph looks amateurish. Ideally, I'd like to be able to add a shaded column between the dates but still have the line show through the shaded area. Thanks. Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Excel Charts to PowerPoint | Charts and Charting in Excel | |||
Automatically resize excel charts when exporting them to PowerPoin | Charts and Charting in Excel | |||
insert excel charts as objects | Charts and Charting in Excel | |||
insert excel charts as objects | Excel Discussion (Misc queries) | |||
Excel Charts | Charts and Charting in Excel |