Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

BUG in Excel 2007 - Plot charts w/data labels

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  7 updates updating problem  
Author Message
Blake M

External


Since: Jul 27, 2009
Posts: 1



(Msg. 1) Posted: Mon Jul 27, 2009 6:55 am
Post subject: BUG in Excel 2007 - Plot charts w/data labels
Archived from groups: microsoft>public>excel (more info?)

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.

 >> Stay informed about: BUG in Excel 2007 - Plot charts w/data labels 
Back to top
Login to vote
Bernard Liengme

External


Since: May 27, 2009
Posts: 6



(Msg. 2) Posted: Mon Jul 27, 2009 11:18 am
Post subject: Re: BUG in Excel 2007 - Plot charts w/data labels
Archived from groups: per prev. post (more info?)

Hello Blake,
I would love to investigate this but I need more info.
Please define "plot chart"
When you say "Then, add a plot chart series (again with date x-axis) and add
data labels to it" do you mean add a series to the existing chart using
PasteSpecial?
Why do we need to change to primary x-axis; will this not be automatic
Maybe you could send me a sample file - get my email address from my website
best wishes

 >> Stay informed about: BUG in Excel 2007 - Plot charts w/data labels 
Back to top
Login to vote
Bernard Liengme

External


Since: May 27, 2009
Posts: 6



(Msg. 3) Posted: Mon Jul 27, 2009 11:25 am
Post subject: Re: BUG in Excel 2007 - Plot charts w/data labels
Archived from groups: per prev. post (more info?)

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?
 >> Stay informed about: BUG in Excel 2007 - Plot charts w/data labels 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..

Help with converting data in Excel - Hello all, I have been working with a client of mine for the last few weeks to get a simple data conversion taken care of. However it has turned out to be more difficult than I expected. I was provided a *.txt file that had tons of columns and extra..

How to cluster data with Excel - Dear all, excuse me for this maybe "too simple" question.. I am trying to find a way to "cluster" simple data on an excel sheet Example: Variable a Variable b Variable c Case 1 1 0 ...

Excel 2007 "Trusted Locations" - Is there any way to get Excel 2007 to let you use removable media as a "trusted location"? my a*istant has a Zip drive hooked to her PC that she's using as basically an external hard drive, but whenever she opens a saved spreadsheet, it alw...
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]