Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 8
Question 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   Report Post  
bj
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert data into chart Sybil227 Charts and Charting in Excel 2 April 12th 05 02:29 PM
Find and replace data in an Excel chart object Cawen Charts and Charting in Excel 2 March 31st 05 06:47 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM
Setting up data to create a chart George Murray Excel Worksheet Functions 0 November 8th 04 05:33 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"