what happened to[LINK] chart-wrksht,when not same page? (same Wrkb

B

Boswell

I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not
'outline' it's data returning to the Wrksht.
How do you EDIT?

(e-mail address removed)
 
A

Andy Pope

Hi,

Simply selecting the series will not change sheet to show you data as
you have discovered. Try using the Source Data dialog, this will allow
you to swap sheets and see and adjust the data used.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where's the missing chart? 6
Embed the same Excel multiple times 0
Format column widths from one table to a separate table on same page 1
Odd Chart Format Results 1
sideways stacked bar charts with line series on the same axis 0
For chart syles, why doesn't color order match series order? 1
Line chart with dotted lines rendered poorly in presentation mode 0
Stack Chart Help 1

Top