Using IF functions in charts

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Data points in chart incorrect 0
Scatter chart with categories on x-Axis 2
change chart primary horizontal axis label or name 1
Cannot see and gantt charts or other displays 0
Average bar charts with individual data points 2
Chart type for machine timing diagram? 3
XY scatter plot with more than 32000 rows in Excel 2003 0

Top