View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default how do I add in a dinamic graph the total as a new series?

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