Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bar Chart To Line Chart for last 3 points only
Hi There,
hopefully someone knows the answer, i have a simple chart going from january to December. The chart info is actuals for January through to September which are shown as a bar graph, what i want to do is create a line graph showing the forecast for October through to December. Rather than creating a new row of forecast data. Is it possible for me to insert the forecast numbers in the actuals series and change the bar chart to a line for these three months only. i.e January to September Bar Graph and October to December line graph. thanks Big H |
#2
|
|||
|
|||
I'm afraid not. I believe you'll have to create another series for the line
graph. "Big H" wrote: Hi There, hopefully someone knows the answer, i have a simple chart going from january to December. The chart info is actuals for January through to September which are shown as a bar graph, what i want to do is create a line graph showing the forecast for October through to December. Rather than creating a new row of forecast data. Is it possible for me to insert the forecast numbers in the actuals series and change the bar chart to a line for these three months only. i.e January to September Bar Graph and October to December line graph. thanks Big H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Null points in a line chart | Excel Discussion (Misc queries) | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |