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.
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.
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" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
>
I did think of making my own chart but not of using Transform. Thanks for
the suggestion!
"Bernard Liengme" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
>> 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.
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks