BUG in Excel 2007 - Plot charts w/data labels

B

Blake M

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.
 
B

Bernard Liengme

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aligning tick marks and labels on line charts or scatter charts 2
Overlapping 2 charts (XL2003) 2
Data Labels Disappearing 0
X-Axis Appearing in Plot Area 2
Scatter plots in excel 2007 1
Data Labels for a chart in Excel 2
X-axis labels in charts 1
Excel Problem with x axis labels in Excel 2010 chart 2

Top