Add Single Data Item to a Chart

  • Thread starter Thread starter Kevin2
  • Start date Start date
K

Kevin2

I am an Excel novice and this is my first time posting to this forum.
Please be kind and explicit.

I have a chart that, among other things, has a moving (running) average
over a range of values specified by the user. For example, the user
can specify how many values to calculate the average for e.g. the last
3, the last 5, or the last 10 values. It can be any number the user
chooses.

I would like to display the number of values selected by the user
somewhere on the chart, in the title, near the title, in the header or
footer, etc.

Thanks!

Kevin
 
If the number is entered on a worksheet, you can refer to that cell in
the chart:

Select the chart
Type an equal sign
Click on the cell that contains the number
Press the Enter key.
Drag the text box to any location in the chart area, and format the text
as desired.
 
Back
Top