Autoentries in charts

  • Thread starter Thread starter Brad Gover
  • Start date Start date
B

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?
 
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
 
Back
Top