PC Review


Reply
Thread Tools Rate Thread

BUG in Excel 2007 - Plot charts w/data labels

 
 
Blake M
Guest
Posts: n/a
 
      27th Jul 2009
To duplicate this bug, create a chart with two lines with an x-axis
that contains consecutive dates. Then, add a plot chart series (again
with date x-axis) and add data labels to it. IMPORTANT: Then, change
the plot chart to plot using the primary axis. Finally, save and
reopen the file. The data labels disappear and you cannot re-add them.
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      27th Jul 2009
I think I have it.
"Plot chart" = XY chart
Also we need to format the Line chart to have the x-axis labels aligned with
tick marks before adding the third series
But I find that the data labels are still visible after changing third
series to Primary Axis.
Also: why would we want to mix Line and XY when the dates are consecutive?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Blake M" <(E-Mail Removed)> wrote in message
news:3fc8beb4-f245-4cb6-9907-(E-Mail Removed)...
> To duplicate this bug, create a chart with two lines with an x-axis
> that contains consecutive dates. Then, add a plot chart series (again
> with date x-axis) and add data labels to it. IMPORTANT: Then, change
> the plot chart to plot using the primary axis. Finally, save and
> reopen the file. The data labels disappear and you cannot re-add them.



 
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
Charts freeze in Excel 2007 using larger plot size crtrading Microsoft Excel Charting 0 1st Aug 2009 04:24 PM
conditional formatting of data labels in excel 2003 XY plot nononono General Software 0 28th Jul 2009 12:03 PM
Charts - Gradient fill Plot Area in Excel 2007 Geoff Budd Microsoft Excel Charting 4 4th Feb 2009 05:44 PM
Data labels for Excel 2007 Charts Courtney Microsoft Excel Discussion 0 19th Jan 2009 06:28 PM
Excel 2007 Chart Plot #N/A Data labels Dave Microsoft Excel Programming 1 17th Apr 2008 09:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:48 PM.