modify values in Graph

[Ammar]

Hi!
This is what I have:

A
1 12
2 13
3 14

I need to plot a graph that would refer to the values above divided by
2.
I'm aware that I could make a reference table what would recalculate
the values and have it displayed, but I'm wondering if there is some
direct aproach to this issue.
something like setting the datarange to =(Table1!$A$1:$A$3)/2
TIA

 

[Tom Ogilvy]

I don't think you can do that directly, but you can create a defined name
(insert=>Name=>Define). Put you formula in as the refers to and assign the
series to that name.

It worked for me.

 

[Tushar Mehta]

You could use a named formula (Insert | Name > Define...) that refers
to A1:A3/2, and use the named formula in the chart. But, using another
column is by far the more transparent way to go.

Still, for more on how to use a named formula in a chart, see the first
2 links on the 'Dynamic Charts' page at http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions