alignment of numbers in a data table shown on the chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am formatting the datatable data using a custom number format of #,##0.0,
to put amounts in millions with 1 decimal. However the numbers are not
aligned to the right but are centered when they appear on the chart. How do
you align the numbers in a datatable?
 
Gary H said:
I am formatting the datatable data using a custom number format of #,##0.0,
to put amounts in millions with 1 decimal. However the numbers are not
aligned to the right but are centered when they appear on the chart. How do
you align the numbers in a datatable?
Click to expand...

I don't think you can, to tell the truth. Even if you right-click and choose
Format Data Table, the dialog doesn't have any kind of horizontal alignment
options.

I think you'll have to fake it by either adding manual textboxes for the
numbers or by ungrouping the chart (or a copy of the chart) and re-aligning
the textboxes.
 
Back
Top