Changing bar graph legend?

  • Thread starter Thread starter Jess D
  • Start date Start date
J

Jess D

I am a teacher trying to teach students how to graph rivers in differen
continents and their length. I can get the rivers and length graph, bu
I want the legend to show only the continents (e.g. I have 2 rivers i
Europe and want them both the same colour and the legend to say Europ
for that colour). The only way I seem to be able to include th
continents in this way is for the legend to say both the continent an
the river name, which is a bit redundant since the river name i
already on the x-axis. Is there any way of putting information only i
the legend? I hope this description is clear enough. I have bee
playing around with this for 2 days and any help would be muc
appreciated!
Thanks,
Jes
 
Set up your data with the continent names across the top, and the river
names down the left side:

Europe Africa
Danube 580
Thames 290
Congo 302
Nile 775

Select all the cells, and create a column chart.
 
You're welcome! Good luck with your project.

And don't use my data for the river lengths -- they may be a bit off. <g>
 
Back
Top