View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Comments on data points

Hi,

For this you are going to have to show us your data layout and tell use
exactly what data you want to graph and what cell you are clicking to show
the chart.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael R" wrote:

I am recording daily turnover data. Occasionally alongside this I also
register some explanations for extraordinary events eg "new dealership opened
today"

The turnover data is then presented on a line chart using the "dynamic area"
technique (thanks for your help with that!).

Now I would like to show the verbal explanations in the graph too - I was
thinking of possibly adding another data series as bar-chart (bar hight being
constant at "max turnover + something" and then somehow get the explanations
displayed in those bars as labels - but so far unsuccessfully.

Any idea how to achieve this?