Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 205
Default charts exclude cell with formula

hi!
how to exclude empty cell with formula from a chart?i have a table of
26R*50C that contains formula.the formula will returns #N/A for cells with no
data.currently the cells with data is 18R*16C and these size will always
change.
then i create a chart from the data that will change due to its data via
this macro:

Sub updateChart()
Sheets("Sheet 1").ChartObjects(1).Chart.SetSourceData _
Source:=Sheets("Sheet 2").Range("B2").CurrentRegion, PlotBy:=xlColumns
End sub

the macro runs perfectly with cells without formula but when it comes to
cells with formula,it will return the zero values to chart.
what am i doing right now is copy valuable cells to another cells and create
& update the chart from there.but its running very slow since i need to use
macro to copy it.
Sub MyMacro1()

a = 1
b = 1
y = 53

Do While Cells(a, b).Value < ""
x = a
Do While Cells(x, b).Value < ""
Cells(x, y).Value = Cells(x, b).Value
x = x + 1
Loop
b = b + 1
y = y + 1
Loop

End Sub

is there any other ways to solve this?thanks!
--
Regards,
Linda
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude Sat and Sun, Median Formula Bre-x Excel Discussion (Misc queries) 2 September 5th 07 07:04 PM
How do I exclude cells from a formula? braitman Excel Discussion (Misc queries) 3 December 4th 06 09:18 PM
Is there a way that I can exclude a formula from being printed? Dhbomb2k1 Excel Discussion (Misc queries) 4 July 8th 06 02:47 AM
Excel 2003 - SUM Formula - exclude cell Peppermint Excel Worksheet Functions 2 January 4th 06 05:53 PM
Exclude a cell from calculating Drew Excel Worksheet Functions 2 February 4th 05 09:05 PM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"