how to show all digits in a "Data Table"

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

Guest

I have a trend chart, its data table showing 6 digits for 12 periods. But it
won't show all digits on the chart, what's the best way to show all digits in
the data table?
 
Hi,

First, note that if the cell is formatted to 3 decimals but there is an 8
digit decimal, the cell format will control the number of decimal places that
can show on the chart.

There is really no very good way. However, you can reduce the font size and
more decimals will display. Second you can widen the chart or the plot area,
that will allow more room for displaying decimals.
 
Have you tried formatting the source data to show all 6 decimal places?
Heres how...
Highlight the source cells
Right click and select format cells
on the number tab;
Category: Number
Decimal places: 6
Then click Ok

One other thought is that the chart may be to narrow to display all the
digits..if so,
try making the chart wider or making the text size smaller
 
Back
Top