Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Laurel
 
Posts: n/a
Default Alignment within a chart's data table

Is there a way to overcome Excel's inability to decimal-align or right-align
numbers in the cells of a data table that is displayed as a chart option?
Alignment is easy in spreadsheets but in data tables within charts, it seems
to be impossible.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme
 
Posts: n/a
Default Alignment within a chart's data table

Have you thought of making your own chart table.
Copy the data to cells under the chart using Past Special Transform if
needed
Make borders around the cells; adjust size to match chart
Print
A lot of work maybe but a possible solution if alignment is so important
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Laurel" wrote in message
...
Is there a way to overcome Excel's inability to decimal-align or
right-align numbers in the cells of a data table that is displayed as a
chart option? Alignment is easy in spreadsheets but in data tables within
charts, it seems to be impossible.




  #3   Report Post  
Posted to microsoft.public.excel.newusers
Laurel
 
Posts: n/a
Default Alignment within a chart's data table

I did think of making my own chart but not of using Transform. Thanks for
the suggestion!

"Bernard Liengme" wrote in message
...
Have you thought of making your own chart table.
Copy the data to cells under the chart using Past Special Transform if
needed
Make borders around the cells; adjust size to match chart
Print
A lot of work maybe but a possible solution if alignment is so important
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Laurel" wrote in message
...
Is there a way to overcome Excel's inability to decimal-align or
right-align numbers in the cells of a data table that is displayed as a
chart option? Alignment is easy in spreadsheets but in data tables within
charts, it seems to be impossible.






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
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table Data Filter Problem Pepikins Excel Discussion (Misc queries) 0 June 16th 05 09:12 AM
Pivot Table - max rows allowed in data range dmotika Excel Discussion (Misc queries) 2 May 26th 05 05:52 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


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