| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Continuation in combination chart
I have a combination chart that shows bars for each months sales projections
and actual sales. I also have lines that represent the cumulative actual sales and the cumulative projected sales. I would like to show the actual sales to date and continue that line from current date with the projected sales. Any Ideas? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Continuation in combination chart
I did this for a line-chart-only chart here, but it can easily be extended
to your combo chart: http://peltiertech.com/WordPress/200...area-charts-1/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "CB" wrote in message ... I have a combination chart that shows bars for each months sales projections and actual sales. I also have lines that represent the cumulative actual sales and the cumulative projected sales. I would like to show the actual sales to date and continue that line from current date with the projected sales. Any Ideas? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Continuation in combination chart
Jon,
Thanks so much. You have ended my frustrations. I was almost there but didn't realize the cells had to be null. Thanks again, Cheryl "Jon Peltier" wrote: I did this for a line-chart-only chart here, but it can easily be extended to your combo chart: http://peltiertech.com/WordPress/200...area-charts-1/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "CB" wrote in message ... I have a combination chart that shows bars for each months sales projections and actual sales. I also have lines that represent the cumulative actual sales and the cumulative projected sales. I would like to show the actual sales to date and continue that line from current date with the projected sales. Any Ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Combination Chart using a Column and Line | Charts and Charting in Excel | |||
| Combination of stock chart and line chart | Charts and Charting in Excel | |||
| Line disappears from combination chart | Charts and Charting in Excel | |||
| 1 Bar, 2 Line Combination Chart Nightmare - Help!! | Charts and Charting in Excel | |||
| Combination chart stacked bar/line | Excel Discussion (Misc queries) | |||
Linear Mode
