| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
A Bar Chart with 1 Line
I've never asked a chart question before. Is it possible to create a bar
chart from a data list and then have 1 line in my chart that represents the average of all the bars. This may be simple, but I don't know how to do it. Thanks... -- Don Rountree |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A Bar Chart with 1 Line
Hi Don,
Add a new series to your data which is the average. Although you can do it with just two points, its easier to just extend the series as far as the other series. Plot this along with your other series, then on the chart select just that series and choose the command Chart, Chart Type and choose Line. One the average line is added you may want to double click it and set Markers to None. -- Cheers, Shane Devenshire "Don" wrote: I've never asked a chart question before. Is it possible to create a bar chart from a data list and then have 1 line in my chart that represents the average of all the bars. This may be simple, but I don't know how to do it. Thanks... -- Don Rountree |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A Bar Chart with 1 Line
Hi,
Yes it's possible. You just need to add another series to plot the line with. http://www.andypope.info/charts/averageline.htm Cheers Andy Don wrote: I've never asked a chart question before. Is it possible to create a bar chart from a data list and then have 1 line in my chart that represents the average of all the bars. This may be simple, but I don't know how to do it. Thanks... |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A Bar Chart with 1 Line
Thank you. A simple thing to do. I couldn't see the forest for the trees.
-- Don Rountree "ShaneDevenshire" wrote: Hi Don, Add a new series to your data which is the average. Although you can do it with just two points, its easier to just extend the series as far as the other series. Plot this along with your other series, then on the chart select just that series and choose the command Chart, Chart Type and choose Line. One the average line is added you may want to double click it and set Markers to None. -- Cheers, Shane Devenshire "Don" wrote: I've never asked a chart question before. Is it possible to create a bar chart from a data list and then have 1 line in my chart that represents the average of all the bars. This may be simple, but I don't know how to do it. Thanks... -- Don Rountree |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Linear Mode
