| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show goal in chart
I have the months in column A and the data in column B. I am doing a bar
chart - everything working fine. Now I need to add the goal as a line going across the chart. How would I do this? For instance, the goal is 50. So I want a line going across the chart at 50. Thanks in advance. |
|
#2
|
|||
|
|||
|
Show goal in chart
Hi,
Here are some examples http://peltiertech.com/Excel/Charts/AddLine.html http://www.andypope.info/charts/averageline.htm Cheers Andy jh3016 wrote: I have the months in column A and the data in column B. I am doing a bar chart - everything working fine. Now I need to add the goal as a line going across the chart. How would I do this? For instance, the goal is 50. So I want a line going across the chart at 50. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show both value and percentage on Waterfall Chart | Charts and Charting in Excel | |||
| How do I show range of data in an area chart? | Charts and Charting in Excel | |||
| how do I set up a pie chart to show % of same value entries | New Users to Excel | |||
| Goal Line in chart but not on data tabel | Charts and Charting in Excel | |||
| hide column but show chart | Charts and Charting in Excel | |||
Linear Mode
