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" <(E-Mail Removed)> wrote in message
news:F48D2D23-3ADF-455F-BB8D-(E-Mail Removed)...
> 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?

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.

--
Echo [MS PPT MVP]
http://www.echosvoice.com