View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
tom tom is offline
external usenet poster
 
Posts: 570
Default charting non-contiguous data

Works perfectly....thanks so much!

"Bernard Liengme" wrote:

If I had this problem I would contrive to collect the data to be plotted in
a contiguous range.
Suppose your data is in Sheet1 B21:IR21
On another sheet in A1 enter =INDEX(Sheet1!$A$21:$IR$21,2+(COLUMN()-1)*5)
Copy this AY1
Now plot this data - the chart can be anywhere you like - it need not be on
the sheet with the data.
To make the chart dynamic change the formula to
=IF(INDEX(Sheet1!$A$21:$IR$21,2+(COLUMN()-1)*5),INDEX(Sheet1!$A$21:$IR$21,2+(COLUMN()-1)*5),NA())
and plot the whole range A1:AY1. When cells on Sheet1 are blank, the data to
plot will display #N/A and this will be ignore by the chart engine.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom" wrote in message
...
Hi all,
Can someone tell me how to add non-contiguous data to a chart. My data is
in
B21, G21, L21........IR21. Ideally, the chart would auto-update to include
data as it is entered on a weekly basis.

Thanks!