Using IF functions in charts

  • Thread starter Thread starter sharon
  • Start date Start date
S

sharon

Can anybody tell me if excel lets you use an IF function in a dat
series of a chart? If not how can I plot the data without changing th
order of the data?


Sharo
 
Create two data series in the worksheet. One will contain the values
that satisfy the TRUE part of the IF statement, the other the FALSE
part. Plot these two series.

--
Regards,

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