Linked Charts Lose Formatting
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 |
Linked Charts Lose Formatting
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. "T. Jenkins" wrote: 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 |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com