I'd like to put values over a simple bar/column chart in excel.
A similar question was asked for R, and I know how to get my data into R, but not how to make the charts. What I'm doing is very simple seems easier to do in Excel than learning how to do it in R.
Best Answer
Assuming you're using Excel 2007, data labels are added through the "Data Labels" selection. As shown below, cells A2:A5 contain the data Items. Cells B2:B5 contain the data Values.
1) Select cells A2:B5
2) Select "Insert"
3) Select the desired "Column" type graph
4) Click on the graph to make sure it is selected, then select "Layout"
5) Select "Data Labels" ("Outside End" was selected below.)
If you don't want the Values as the Labels, you can click on the desired label, click twice so that it's the only thing selected, and then enter your new label information in the formula bar.