Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default HELP REF. NEW DATA ONLY AS i MOVE TO ANY CELL IN THE NEW ROW/RANGE

I need a macrocode to change the data range in an inbeded chart as I move to any cell in the new row/range. this will be for the same type of data from a specific range of rows. If you can help, I would be most grateful! I am an experienced Excel
user, but only a beginner VBA code writer. I feel it will take me a
while to learn the code development well enough and I am on a time
constraint.

Thanks, Areidski



  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

No need for VBA code. Can be done by leveraging a little known fact of
named ranges using relative references.

Suppose your data are in A:C with A as the series name and B as the x
value and C as the y value. Suppose your data start in row 2.

With any cell in row 2 selected, create three names:
SerName =Sheet2!$A2
XVal =Sheet2!$B2
YVal =Sheet2!$C2+NOW()*0

Create a chart. Use the named formula for the various data sources.
For an intro see 'Names in Charts'
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html

When done, the series formula should look like:
=SERIES('relative name in chart.xls'!SerName,'relative name in
chart.xls'!XVal,'relative name in chart.xls'!YVal,1)
where 'relative name in chart.xls' is the name of your workbook.

Now, select any cell in a different row (say, row 3) and press F9. The
chart will show the information from that row.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I need a macrocode to change the data range in an inbeded chart as I move to any cell in the new row/range. this will be for the same type of data from a specific range of rows. If you can help, I would be most grateful! I am an experienced Excel
user, but only a beginner VBA code writer. I feel it will take me a
while to learn the code development well enough and I am on a time
constraint.

Thanks, Areidski




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
Using a Text / Data output as a cell reference Jimboski Excel Discussion (Misc queries) 1 February 11th 05 08:31 PM
Repeat Cell Data Pinky Excel Worksheet Functions 1 January 18th 05 06:38 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 06:59 PM
Retrieve last cell with data JimDandy Excel Worksheet Functions 2 November 20th 04 07:50 PM


All times are GMT +1. The time now is 12:37 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"