You need to include all 6 in the chart in order to populate the data table.
You can then format 3 to have no Line style. This will remove them from the
chart.
You can also remove individual legend entries by selecting and deleting
them.
Cheers
Andy
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.