View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Guate Guate is offline
external usenet poster
 
Posts: 3
Default 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!