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.

|cite
$\endgroup$

locked by whuber♦ Jun 18 '15 at 14:22

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. See the help center for guidance on writing a good question.

Read more about locked posts here.

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

|cite
$\endgroup$
  • 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 '11 at 1:12
  • $\begingroup$ Ah-ha.... I googled PITA to figure out what that means. $\endgroup$ – bill_080 Oct 11 '11 at 1:18
  • $\begingroup$ It's a useful acronym - slightly more polite than saying what it stands for :) $\endgroup$ – paul Oct 11 '11 at 4:12

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