Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar and Line graph combi?
Hi, i'm being asked to present some 5 year forecast data, which historically
has been broken down into monthly results represented on a bar chart. However the request has come in that they would like me to add a line representing a previous forecast, to compare accuracy - i'm struggling to incorperate a line to my bar-chart that has fixed value points and represents another series of data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar and Line graph combi?
Hi,
When trying to combine Bar and Line you need to use the XY-scatter rather than the Line chart type. This will allow you to specify both the X, value, position and more importantly the Y, bar alignment, position. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "GD" wrote in message ... Hi, i'm being asked to present some 5 year forecast data, which historically has been broken down into monthly results represented on a bar chart. However the request has come in that they would like me to add a line representing a previous forecast, to compare accuracy - i'm struggling to incorperate a line to my bar-chart that has fixed value points and represents another series of data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph of 2nd serious in the Line type graph is not connected | Excel Worksheet Functions | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel |