Adding and deleting chart data series

- You can change the source data…for a chart in a number of ways.…We're on a worksheet called Paste Chart Data.…No chart here yet, but I'm going to create…a chart based on the data here…for domestic Europe and Asia.…Data is highlighted.…I'll create a column chart,…clustered column.…There it is.…A meeting is coming up…and it turns out that we don't really…wanna be discussing in the meeting Europe.…So Europe is represented here by the orange column.…So I could simply click the orange column, press delete.…

Of course, I could have created the chart…initially by highlighting the data this way…and then letting go of the left mouse button…and using the command key,…highlighting the data this way…to create the chart using just that data.…That's, in effect, what I'm seeing right now.…But we have the ability to take out a range.…What if we wanted to add Europe back in?…We've done other things in the meantime maybe.…We should be able to take the data from Europe here,…do a copy.…You could choose command C…or right click and Copy.…