#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 131
Default Excel Help

I am doing a graph and the number over $100K come up ####### and won't print
in the space for them -- the figures show in a little yellow box below but it
won't let me put in typed figures???
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Excel Help

Can you double-click on the number Number Custom ##.
Then, Scale Display Units Millions (or whatever you want) and check
'Show Display Units Label on Chart'

If that's not it exactly, fiddle with it until you get the results you want.


Regards,
Ryan---
--
RyGuy


"Lynn" wrote:

I am doing a graph and the number over $100K come up ####### and won't print
in the space for them -- the figures show in a little yellow box below but it
won't let me put in typed figures???

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



All times are GMT +1. The time now is 04:16 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"