Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can i format number in a legend of a chart 1

Status
Not open for further replies.

hatemgamil

Programmer
Mar 18, 2010
41
Hi,

How do i format a legend on a graph?

i have a legend that shows numbers
like this 2,010.00 and 2,009.00 i want to format these numbers to be like these 2010 and 2009

thnx
 
YOu can try

Right-click your chart, select Chart Options, and then select General and Numbers Tab.

Or converting year field to text

@Year
Totext(yearfield, 0,"") and then recompiling chart to use this formula instead.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top