![]() |
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. |
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 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. |
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 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