Linked Charts Lose Formatting

[T. Jenkins]

I'm creating a "dashboard" for my company, and as part of this, am linking
various information (charts, tables, documents) into one Excel file, and I'm
then saving the file as a web page for others to browse.

Everything seems to be working, but some of the charts I've copied from
another Excel file are losing their numeric formatting. For example, the
horizontal axis is formatted as dates in the original file, but in the linked
file, they show up as the date serial number (i.e., 39325, 39326, etc.).
Also, the numbers in the data table for the chart are no longer formatted,
and all decimal places are displayed.

I actually copy and pasted the charts, so they appear to be regular Excel
charts, with the source data in another file, but for some reason, Excel
seems to be forgetting the numeric format for the linked data. I suppose I
could link the data itself, then format it in the dashboard file, but that's
a bit more complex than I was hoping for.

Any tips on doing this sort of thing?

Todd

 

[Suleman Peerzade]

Hi,

You can combine the data in your existing workbook by copying the data
required from another workbook.

This way the required data would be in the same workbook and the charts that
are linked to the data will be updated automatically and formatting will not
be erazed.