Discussion Locked

NEED EXCEL EXPERT! WORKING WITH CHARTS

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working with a chart and I'm trying to figure out how to make this chart grow continually without having to go in and redefine my ranges everytime I add information. I realize it will update if I change or add information within my defined range, but I add info to this chart everyday and I need the chart to reflect this. I know there is a way to do this by inserting a name for my range and using the OFFSET funtion in my "refers to field" spot, but I can't get it to work. Anyone want to take a stab at this? I know it can be done. I'll even email you the exact spreadsheet I'm working with. Please help!

8 replies

by dklippert

Have you looked at Knowlege Base article Q104185? It seems to cover the problem.
If it doesn't meet your needs, I'd be glad to look at a sample of your data.

by joshwilson

Excel allows you to reference a cell range with the column or row header information only. For example, to reference cells in column B, you could reference B1:B500 as long as you don't add more rows. However, a more elegant technique is to reference the range this way: B:B. This tells Excel to take all of column B as the range, no matter how many rows exist. This technique also works for rows (for example, referencing all of row 3 as 3:3).

This discussion is closed to new replies.