This must be a very stupid question ... how do replace the labels in a bar chart? Right now they say "Series 1" "Series 2" etc. I tried long and hard to change it with no suceess. Thanks S.
In the edit chart section, go to the Format Chart tab at the top. Then select Series in the list on the left. Then change the names in the white boxes under Title.
I had the same initial problem. Its not as obvious as it should be.
Hope it helps,
Thanks. ! Doh!
More detail, in italics:
"Then in the Series area below the Chart Preview change the names in the white boxes under Title."
It would be great if this could automatically set the title to data item name, with an option to override it manually.