| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Chart
Hi All
I have a bar chart with different percentages displayed as the columns. Or target is 70%. Is it possible to have a target line added to the bar chart to show how many meet the target? In a line graph I just add a target column to create the target line but this will not work with a bar chart Any help greatly appreciated Kind regards Rexmann |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Chart
opps forgot to say using Excel 2003
"rexmann" wrote: Hi All I have a bar chart with different percentages displayed as the columns. Or target is 70%. Is it possible to have a target line added to the bar chart to show how many meet the target? In a line graph I just add a target column to create the target line but this will not work with a bar chart Any help greatly appreciated Kind regards Rexmann |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Chart
Hi,
Details can be found here. http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rexmann" wrote in message ... Hi All I have a bar chart with different percentages displayed as the columns. Or target is 70%. Is it possible to have a target line added to the bar chart to show how many meet the target? In a line graph I just add a target column to create the target line but this will not work with a bar chart Any help greatly appreciated Kind regards Rexmann |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Chart
Hi Andy
Nice one, sorted my problem Cheers rexmann "Andy Pope" wrote: Hi, Details can be found here. http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rexmann" wrote in message ... Hi All I have a bar chart with different percentages displayed as the columns. Or target is 70%. Is it possible to have a target line added to the bar chart to show how many meet the target? In a line graph I just add a target column to create the target line but this will not work with a bar chart Any help greatly appreciated Kind regards Rexmann |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
Linear Mode
