I am doing a project that requires me to keep adding new rows of data to my XY plot when new data is gathered. So lets say column A is team name column B is the date the data was taken on and column C is their score. Instead of having to go through and fix the graphs each time new data comes in is there a way that I can say series name: ="Team A" X Values: = the rows in column B that correspond to rows in column A with value "Team A"?
Hi skakaiser,
Instead of setting the ranges of the X and Y axes manually, use dynamic named ranges. This way your graph will auto update as rows are added.
For example, click Insert -> Name -> Define. Type in a name (e.g. ColumnA) then in the Refers To: box, put the formula:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)
This will create a dynamic range for column A. Do the same for column B. Insert -> Name -> Define, call it ColumnB (for example), then use the Refers To: formula
=OFFSET($B$1,0,0,COUNTA($B:$B),1)
In your chart's properties, set the X axes values to one range the and Y values to the other range.
That will leave me with about the same amount of work, since I need to do about 20 graphs on the same spreadsheet. When I get new data it comes in a whole new spreadsheet since there are several data points entered each time. Is there any way to do what I asked without having to set up dynamic ranges for each new sheet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks