Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
8uv 8uv is offline
external usenet poster
 
Posts: 1
Default Can excel display text in CHART's data table?

All my text are displayed as "0".......just want to keep some comments nicely
in there.Not sure whether excel can do this. Or anybody knows other better
way?

something like this:
para1 1.2 1.3 1.4
para2 1 7 100
comments bad good excellent
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Can excel display text in CHART's data table?

Hi,

The chart data table is very limited in terms of formatting.

You would be better using cells to display the information you want. And
position the chart above them

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"8uv" wrote in message
...
All my text are displayed as "0".......just want to keep some comments
nicely
in there.Not sure whether excel can do this. Or anybody knows other better
way?

something like this:
para1 1.2 1.3 1.4
para2 1 7 100
comments bad good excellent


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
How to let pivot table chart's format stay after refreshing data. JJ Charts and Charting in Excel 2 December 2nd 08 05:36 PM
Date formatting on a Pivot Chart's Data Table [email protected] Charts and Charting in Excel 2 May 23rd 06 03:53 PM
Alignment within a chart's data table Laurel New Users to Excel 2 January 4th 06 02:56 PM
Text data appears as 0 in my Pivot table - how do I display as tex Murray Snedden Excel Worksheet Functions 1 August 9th 05 07:44 PM
Display Text in the Data Area of a Pivot Table Wayne Wilmeth Excel Discussion (Misc queries) 0 August 4th 05 10:12 PM


All times are GMT +1. The time now is 10:06 PM.

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

About Us

"It's about Microsoft Excel"