| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
overlay average & goal lines to bar graph w/out showing in legend
I have a 4-subject bar chart and want to overlay the goal (fixed number) and
the average score (variable number) as a line onto the bar graph. The problem I have is that I must include the goal and avg score data in the bar chart in order to use the trendline feature. How do I include it without having it appear in the legend? |
|
#2
|
|||
|
|||
|
You can include series on the chart and delete their display on the legend.
"Violet Maven" <Violet wrote in message ... I have a 4-subject bar chart and want to overlay the goal (fixed number) and the average score (variable number) as a line onto the bar graph. The problem I have is that I must include the goal and avg score data in the bar chart in order to use the trendline feature. How do I include it without having it appear in the legend? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graph with one column and two lines | Excel Discussion (Misc queries) | |||
| 'Average' Function on 1500 lines | New Users to Excel | |||
| how differentiate between 3 closely spaced lines in excel graph | Charts and Charting in Excel | |||
| Excel graph column and two lines. Help | Charts and Charting in Excel | |||
| Formatting Graph Grid Lines | Excel Discussion (Misc queries) | |||
Linear Mode
