Posted to microsoft.public.excel.misc

Courtney[_2_] Courtney[_2_] is offline

external usenet poster

Posts: 4

Data Labels for Charts

Hi,
I have charts that are based on dynamically populated data. I need
the
data labels for all of these charts to appear with 0 decimal places.
The dynamic data populates with 2 decimal places (X.XX). Is there a
universal setting I can apply to the worksheet or even the chart
itself, so I do not have to go to each data point/data label and set
the formatting to 0 decimal places?
Thanks,
Courtney

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data labels for charts	Courtney[_2_]	Charts and Charting in Excel	1	January 20th 09 06:00 PM
data labels in charts	Carol Rutledge	Charts and Charting in Excel	1	November 24th 08 08:40 PM
Data labels on charts	Cuylle	Excel Discussion (Misc queries)	1	April 12th 08 12:10 AM
Data Labels on charts	Russell-stanely	Charts and Charting in Excel	2	June 17th 07 09:35 PM
Help with pivot charts and data labels	[email protected]	Charts and Charting in Excel	1	December 15th 04 03:08 PM

All times are GMT +1. The time now is 08:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us