PDA

View Full Version : Scatterplot Illustration Help



akers77
04-06-2015, 07:10 PM
Hi!


I need some help creating and updating a scatterplot. On the first tab on the excel sheet attached, there are some transaction data. I’d like to create scatter plot from the data where the X axis is “Number of Weeks” and the Y Axis is “Amount.” The name would be the actual data point. Tab 2 has an example.


How can I automate this process? (i.e.: if I add new data, it will update the scatter plot).


Thanks for the help! :D

p45cal
04-07-2015, 01:30 PM
cross posted at http://forum.chandoo.org/threads/scatterplot-illustration-help.22792/
akers, please have a read of http://www.excelguru.ca/content.php?184