Series Data Problems

J

Jade7

Okey Dokey....here's the dealeeo....HELP! HELP! I have a Excel 2007 Template
with charts that are driving me nutty! 2 of the 4 charts have the correct
series name of =sheet1 etc. and data series embedded - such as
filename.xltm!blah blah and they are working properly. However, the other 2
have a series name of =sheet1 etc. BUT the data series keeps showing [0]!
instead of sheet1! or filename.xltm! as it should. If I type sheet1! in, to
replace the [0]! the chart and formulas work fine. Yet when I close out and
save the template, and go back in, it is all screwed up again and the 2
charts and formulas aren't working again....UGH! Anybody that can help?
Please?!
 

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

Top