Hello to all,
I am trying to create a graph in excel but rather than a series of data I want to imput values from one cell which will change from day to day. For example the value in the cell could be 5 one day and then 4 on another, depending on other variables. I would therefore like the graph to plot the changes in the cell value over time. Ive had a good look and cant find out how... Would apreciate any help.
Thanks,
Gareth
Pete_UK has already explained to you, in your post on MS site, that you need to keep a history of all the values.
If you create a List object (<=xl2003) or Table (xl2007) and base your chart on that it will auto expand.
Other wise named ranges can be used to make the chart range expand.
Please read the rules regarding cross posting,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks