(Msg. 1) Posted: Tue Aug 05, 2008 5:25 am
Post subject: Preceding Zero's Add to elertz Archived from groups: microsoft>public>excel>charting (more info?)
I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000,
2000-3000. Do you have any ideas on how to hold onto the preceding zeros so
it will list right?
(Msg. 2) Posted: Tue Aug 05, 2008 7:15 am
Post subject: RE: Preceding Zero's Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try custom formatting your axis values.
Double click a value on the axis, and format it accordingly as you would
normally do in Excel itself.
> I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000,
> 2000-3000. Do you have any ideas on how to hold onto the preceding zeros so
> it will list right?
(Msg. 3) Posted: Wed Aug 06, 2008 8:28 pm
Post subject: Re: Preceding Zero's Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You can change the format of these cells in the spreadsheet to Text.
Bear in mind this will not sort correctly in numerical order so you
will need to make sure the line items are in the right order before
creating your chart.
Wigi wrote:
> Try custom formatting your axis values.
>
> Double click a value on the axis, and format it accordingly as you would
> normally do in Excel itself.
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "s. Dost" wrote:
>
> > I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000,
> > 2000-3000. Do you have any ideas on how to hold onto the preceding zeros so
> > it will list right?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office