ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Alignment within a chart's data table (https://www.excelbanter.com/new-users-excel/62907-alignment-within-charts-data-table.html)

Laurel

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.



Bernard Liengme

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.





Laurel

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.








All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com