Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Set Conditions on Chart data
Hi, if anyone has an answer to this I would be most greatful. I have constructed serveral charts, each with its own range of data. Within the data range for each chart the cells contain formulas (an if formula), to allow those months of the year not yet populated with data to remain blank. However my chart is treating the formulas as zero's and plotting them on the chart making it look odd (ie the data suddenly falls to 0 with a long line from the last data point). I have tried setting the 'Chart' settings to 'plot visible cells only' under the 'Options' menu. But this does not alter the chart. I'm trying to find some syntax in Visual basic to maybe set a macro to tell it not to treat the formulas as cell population!!! Any ideas?? Many thanks Wardy XX -- Wardy1 ------------------------------------------------------------------------ Wardy1's Profile: http://www.excelforum.com/member.php...o&userid=27104 View this thread: http://www.excelforum.com/showthread...hreadid=466199 |
#2
|
|||
|
|||
Wardy1 Wrote: Hi, if anyone has an answer to this I would be most greatful. I have constructed serveral charts, each with its own range of data. Within the data range for each chart the cells contain formulas (an if formula), to allow those months of the year not yet populated with data to remain blank. However my chart is treating the formulas as zero's and plotting them on the chart making it look odd (ie the data suddenly falls to 0 with a long line from the last data point). I have tried setting the 'Chart' settings to 'plot visible cells only' under the 'Options' menu. But this does not alter the chart. I'm trying to find some syntax in Visual basic to maybe set a macro to tell it not to treat the formulas as cell population!!! Any ideas?? Many thanks Wardy XX Hi Wardy Instead of blank get your IF statement to return #N/A, they will then not show on the chart -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=466199 |
#3
|
|||
|
|||
Cheers Paul - done the trick. Wardy xx -- Wardy1 ------------------------------------------------------------------------ Wardy1's Profile: http://www.excelforum.com/member.php...o&userid=27104 View this thread: http://www.excelforum.com/showthread...hreadid=466199 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Chart - Data Tables | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |