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
"Guillermo Fuenzalida" wrote:
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.
"David Biddulph" wrote:
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 Biddulph
"Guillermo Fuenzalida" <Guillermo
wrote in message ...
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