| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart Links
I currently am using Excel 97. I've created charts using links to source data that is in dollar and percent formats. But when they pull into the chart data table they do not show the proper format. For example: In the source data worksheet it shows 97%, but when it pulls into the data table for the chart it shows .97437373.
If I open the link then it shows properly, but as soon as I close the link it goes back to the bad format. How can I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
| How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
Linear Mode
