LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 07, 05:12 AM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 205
Default charts exclude cell with formula

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
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
b = b + 1
y = y + 1

End Sub

is there any other ways to solve this?thanks!

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 08: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 04:53 PM
Exclude a cell from calculating Drew Excel Worksheet Functions 2 February 4th 05 08:05 PM

All times are GMT +1. The time now is 02:45 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017