Excel Chart data source
Hi Guys,
Should be a fairly easy one...!
I have a chart that I will be adding data to weekly. I want to add the data, and the chart will update to include this without having to update the range.
Currently, as you can see in attachment, the chart contains a blank area after plotted data.
Any help would be much appreciated.
Many thanks,
Ben
Last edited by BenHatton; 01-30-2017 at 05:50 AM.
two names for graph: _date and _data
Hi Tim!
I adjusted the range on your version and the data is displayed perfectly thank you! However, I am not sure what you mean by 'two names for graph: _date and _data'?
Perhaps you could tell me how you did that?!
Thanks,
Ben
Ah yes, so once I have named each, how do I edit the chart to use the name I have made, opposed to a range of cells?
Ah yes, so once I have named each, how do I edit the chart to use the name I have made, opposed to a range of cells?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks