Chart - Data Tables

#1 June 8th, 2005, 01:11 PM

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

#2 June 8th, 2005, 01:48 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fan charts	Dean	Charts and Charting	7	May 30th, 2005 11:51 AM
Same database or another?	accesskastle	Database Design	2	April 11th, 2005 07:29 PM
Pulling data from 1 sheet to another	Dave1155	Worksheet Functions	1	January 12th, 2005 05:55 PM
How do I get 3 series in sync with the x-axis?	zizbird	Charts and Charting	10	October 25th, 2004 01:23 PM
Help with Data (Table) below my chart	Jon Peltier	Charts and Charting	0	November 20th, 2003 03:36 PM