Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Indicate average value to floating bar chart
I've plotted minimum and maximum values (prices) for a number of products on
a floating bar chart, and want to indicate the average price for each product. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Indicate average value to floating bar chart
Hi,
See the previous post, for the basic idea, but since you now want these figures on all of your bars, I suggest downloading the free XL Chart Labeler from http://www.appspro.com/Utilities/ChartLabeler.htm Then all you need to do is create a colum that gets your Min, Max and Avg and use the chartlabeler to do the connections. If this helps, please click the Yes button. Cheers, Shane Devenshire "Guate" wrote: I've plotted minimum and maximum values (prices) for a number of products on a floating bar chart, and want to indicate the average price for each product. Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Indicate average value to floating bar chart
Hi Shane,
I've downloaded the ChartLabeler but it's not clear to me how to access it, or what you mean by "create a column that gets your Min, Max & Avg and use the chartlabeler to do the connections". Could you provide a bit more detail, please? "Shane Devenshire" wrote: Hi, See the previous post, for the basic idea, but since you now want these figures on all of your bars, I suggest downloading the free XL Chart Labeler from http://www.appspro.com/Utilities/ChartLabeler.htm Then all you need to do is create a colum that gets your Min, Max and Avg and use the chartlabeler to do the connections. If this helps, please click the Yes button. Cheers, Shane Devenshire "Guate" wrote: I've plotted minimum and maximum values (prices) for a number of products on a floating bar chart, and want to indicate the average price for each product. Any suggestions? Thanks! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Indicate average value to floating bar chart
"Guate" wrote: Hi Shane, I've downloaded the ChartLabeler but it's not clear to me how to access it, or what you mean by "create a column that gets your Min, Max & Avg and use the chartlabeler to do the connections". Could you provide a bit more detail, please? "Shane Devenshire" wrote: Hi, See the previous post, for the basic idea, but since you now want these figures on all of your bars, I suggest downloading the free XL Chart Labeler from http://www.appspro.com/Utilities/ChartLabeler.htm Then all you need to do is create a colum that gets your Min, Max and Avg and use the chartlabeler to do the connections. If this helps, please click the Yes button. Cheers, Shane Devenshire "Guate" wrote: I've plotted minimum and maximum values (prices) for a number of products on a floating bar chart, and want to indicate the average price for each product. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
floating chart | Charts and Charting in Excel | |||
Floating bar chart - How? | Charts and Charting in Excel | |||
Floating Bar Chart | Charts and Charting in Excel | |||
Floating chart | Charts and Charting in Excel | |||
floating bar chart? | Charts and Charting in Excel |