how do I add in a dinamic graph the total as a new series?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add, in a dinamic graphic, a new series: the mean. Is it possible?
I need it to compare each series with the mean.

Thanks in advance. Regards,

Guillermo Fuenzalida
 
The graph won't calculate the mean for you, so you'll need to calculate the
mean as a new series in your data sheet, and then include that series as a
new series in your graph.
 
David,

Thank you for your answer. Unfortunately, I realize I didn't express myself
correctly. English is not my native language.

I have the mean, it's the general total from a dynamic table I created. The
problem is that I want to add that column as a new series in a dynamic
graphic. I can do it manually, but that means that I have to create the whole
series one by one (about 40). Is there any way to do it?

Regards,

Guillermo Fuenzalida.
 
Guillermo,
Have you tried this solution:
Select dynamic graph (right click), select "Source Data".
Select "Series" tab. Select "Add" series.
Name: "="Mean"" (omit first " and last ")
X-values: =Sheet1!$A$2:$A$20 (Sheet1 is what ever your sheet name is)
Y-values: =Sheet1!$B$2:$B$20 (Sheet1 is what ever your sheet name is)
hth
Dennis
 
Back
Top