Chart Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning all. I have several charts in a workbook that captures data from
another workbook. The problem I am having is that the data gets converted
from having two decimal points to four. I have tried formatting the source
data cells with different number formats, ie: general number w/two decimal
places and accounting numbers w/two decimals. Still the charts in the other
workbook show 4 decimal places. Any ideas?
Thanks, Chris
 
Chris -

Change the number formats in the target workbook.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zero's plotted in charts? 1
Custom 0\.00 Format with Comma 4
formatting question 3
Access stripping decimal places in query 1
Numbers changing between sheets 13
Rounding numbers 3
Find 0.00% 1
Formula 1

Back
Top