Chart link question

[Guest]

Hi. I have a list of grades in my grade book E7-E40. What I am trying to see if I can do is have a link or icon put in cell E49 that will automatically bring up a chart based on the grades in E7-E40 when I click on it. Is there a way to do that? I have a lot of charts to make in my gradebook so would it be easier to launch the chart into Word and how would I do that? Sorry if this is confusing and thanks for any help.

 

[Debra Dalgleish]

You can select cells E7:E40, and click the chart wizard button on the
toolbar. Jon Peltier has a charting tutorial on his web site that may
help you:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html