For a pie chart, the default legend entries are what would be the x-
values for another chart. If no such values are specified, XL uses the
numbers 1,2,3, etc.
--
Regards,
Tushar Mehta www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
The way to specify a range is to choose Source Data from the Chart menu, click on the Series
tab, click in the Category Labels box, then choose a range with the mouse.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
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.