| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can i use the IF function in a chart to choose its data series?
Hi all,
I am currently making a chart that needs to take its data from 1 of 2 series', depending on whether cell A1 contains the number 1 or 2. I tried to use the IF function to do this "=IF(A1=1, Range 1, Range 2)", but it just keeps telling me i cant use the IF function in a chart. I cannot find a way to achieve this, and its pretty critical i can, otherwise i'm going to have to start a weeks worth of work again! Thanks Edd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Unstacking a series of data on a 3-D chart | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
