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

Advertisements

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

Top