PC Review


Reply
Thread Tools Rate Thread

Chart data labels are not correct or not displayed

 
 
=?Utf-8?B?Qm9sdG9uIFVzZXI=?=
Guest
Posts: n/a
 
      11th Apr 2006
I have some charts that I've been using for a long time and I notice that
sometimes the data labels do show correctly or not at all. Can someone help?
 
Reply With Quote
 
 
 
 
Kelly O'Day
Guest
Posts: n/a
 
      11th Apr 2006
Bolton User

Can you give us a few more details.

What type of chart (line, XY, column) ???

How is your source data setup?

What do you expect to see for labels, what are you actually getting?

With a little more information, I'm sure we can help.

(E-Mail Removed)





"Bolton User" <Bolton (E-Mail Removed)> wrote in message
news:22562EFB-2802-4BEE-9C03-(E-Mail Removed)...
>I have some charts that I've been using for a long time and I notice that
> sometimes the data labels do show correctly or not at all. Can someone
> help?



 
Reply With Quote
 
=?Utf-8?B?Qm9sdG9uIFVzZXI=?=
Guest
Posts: n/a
 
      11th Apr 2006
Thanks for the response.

What type of chart (line, XY, column) ???
It's a column graph with a percentage line across the top.

How is your source data setup? The data is being pulled from 3 columns of
data (numbers, numbers, and percentage) and one column with titles.

What do you expect to see for labels, what are you actually getting? I
expect to see the correct percentages. Some of the percentages are correct
and some are not and some are displayed at all.

"Bolton User" wrote:

> I have some charts that I've been using for a long time and I notice that
> sometimes the data labels do show correctly or not at all. Can someone help?

 
Reply With Quote
 
Kelly O'Day
Guest
Posts: n/a
 
      11th Apr 2006
Bolton User

This helps a little.

As I understand it, you have a combination column and line chart which has 4
source columns for data:
1. Titles - I assume these show on lower X axis
2. Numbers - 2 sets. Are you showing both? If yes, how? As cluster or
stacked?
3. Percentage line along top

It sounds like you want a combination column and line chart.

Based on your description, it sounds like your category Titles are on lower
x axis and percentages on top X axis.

Can you select your percentage line and read your series formula? Does the
series formula point to the correct x and Y data? What is your x range for
this series and what is your y range?

You can send the file to me at (E-Mail Removed) and I'll take a
look it to see if I can solve your problem.

...Kelly


(E-Mail Removed)






"Bolton User" <(E-Mail Removed)> wrote in message
news9196CD9-6C8B-4543-A6A9-(E-Mail Removed)...
> Thanks for the response.
>
> What type of chart (line, XY, column) ???
> It's a column graph with a percentage line across the top.
>
> How is your source data setup? The data is being pulled from 3 columns of
> data (numbers, numbers, and percentage) and one column with titles.
>
> What do you expect to see for labels, what are you actually getting? I
> expect to see the correct percentages. Some of the percentages are correct
> and some are not and some are displayed at all.
>
> "Bolton User" wrote:
>
>> I have some charts that I've been using for a long time and I notice that
>> sometimes the data labels do show correctly or not at all. Can someone
>> help?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie Chart Data labels Milind Keer Microsoft Excel Misc 0 2nd Oct 2008 04:31 PM
How to add data labels from a series not displayed on a chart =?Utf-8?B?ZG9jdG9yIGJt?= Microsoft Excel Charting 2 1st Mar 2006 12:41 AM
Pie Chart Data Labels =?Utf-8?B?Z2JfUzQ5?= Microsoft Excel Charting 4 26th Jan 2005 02:37 PM
Custom dataGridColumn with two textboxes (or labels) one for each line of data to be displayed? James Radke Microsoft Dot NET Framework Forms 1 28th Jan 2004 09:44 AM
Pie of Pie Chart - Correct input of data Christine Microsoft Excel Charting 1 17th Nov 2003 11:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:59 PM.