Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells lose data when updated HELP! | Excel Discussion (Misc queries) | |||
Lists lose formatting on sort - Mac only? | Excel Discussion (Misc queries) | |||
In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
Multiple Windows - Lose Some Formatting | Excel Discussion (Misc queries) | |||
lose formatting when emailing worksheet | Excel Discussion (Misc queries) |