4
votes
$\begingroup$

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.

$\endgroup$

1 Answer 1

Reset to default
7
votes
$\begingroup$

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.

enter image description here

$\endgroup$
3
  • 2
    $\begingroup$ Perfect, thanks, that's exactly what I was looking for (PITA to find that by googling for it). I'm in Excel 2010, but it works the same way in there. $\endgroup$
    – paul
    Oct 11, 2011 at 1:12
  • $\begingroup$ Ah-ha.... I googled PITA to figure out what that means. $\endgroup$
    – bill_080
    Oct 11, 2011 at 1:18
  • $\begingroup$ It's a useful acronym - slightly more polite than saying what it stands for :) $\endgroup$
    – paul
    Oct 11, 2011 at 4:12

Not the answer you're looking for? Browse other questions tagged or ask your own question.