Chart Data Changes Data Type

A

AJ

Using Excel 2007, I have a line chart in Workbook A that is built from data
in Workbook B. The X axis contains dates. When viewing the chart in Workbook
A the dates a properly formatted when I have Workbook B open. However, when
I close Workbook B the dates change to numbers. When I open Workbook B the
numbers change back to dates. How can I keep the dates in Workbook A to stay
in date format?

Thank you.

AJ
 

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