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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Align Decimals In A PP 2007 Table 3
Align text on bar charts 1
Decimal Align Table Contents 2
Alignment Problem in "3-D Clustered Column" Chart (layout 5) 1
change alignment of numbers in a chart 1
Text alignment in tables 1
aligning objects on a slide 2
Alignment within a chart's data table 2

Back
Top