Autoentries in charts

[Brad Gover]

Help, I have a chart that automatically goes to another
worksheets chart in some other workbook and updates the
chart with that data and not the data I have in my work
sheet. How do I turn off the auto update?

 

[Jon Peltier]

Brad -

You could apply one of these techniques to unlink the chart from the data:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Tushar Mehta]

Select the chart. Then, select Chart | Source Data... | Series tab.
In there select each series and change the category (x) and value (y)
fields to reflect the correct ranges.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions