Using a Fomula to Select Chart Values

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

We want to set the values for a chart series by using a
formula. We want to set the series equal to a range in a
worksheet less the values in a second range.

In the series "Values:" box of the source data dialog box
we want to enter:

=TestSheet!$A$1:$A$6 minus $B$1:$B$6

We can't figure out the right syntax to make the
subtraction happen.

TIA.
 
Do you want to plot the difference between the values in A1:A6 and
B1:B6? If so, in C1, enter =A1-B1. Copy C1 to C2:C6. Plot C1:C6.

--
Regards,

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