Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart - Data Tables
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? |
#2
|
|||
|
|||
It sounds like a formatting issue.
You may need to add a step to round (see round function in help) "lajohn63" wrote: 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? -- lajohn63 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert data into chart | Charts and Charting in Excel | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Setting up data to create a chart | Excel Worksheet Functions |