Excel Charts: Is it possible to add specific text to the bars on a chart?
up vote
1
down vote
favorite
I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each day (i.e. on the 2nd day it'll add the amount of purchaess on the 1st and 2nd, on the 3rd it would be the amount on the 1st, 2nd, and 3rd etc) and the total amount of purchases in August 2015.
There are some low spikes on the Saturdays and Sundays.
So what I want to do is put the day name of the date on top of the bars, e.g. over the 2014 day 1 bar it would say Friday and over the 2015 day 1 bar it would say Saturday.
Is this possible?
Please note that I am using Microsoft Excel 2010.
microsoft-excel microsoft-excel-2010 charts
edited Sep 24 '15 at 10:14
bertieb
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
add a comment |
up vote
1
down vote
favorite
I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each day (i.e. on the 2nd day it'll add the amount of purchaess on the 1st and 2nd, on the 3rd it would be the amount on the 1st, 2nd, and 3rd etc) and the total amount of purchases in August 2015.
There are some low spikes on the Saturdays and Sundays.
So what I want to do is put the day name of the date on top of the bars, e.g. over the 2014 day 1 bar it would say Friday and over the 2015 day 1 bar it would say Saturday.
Is this possible?
Please note that I am using Microsoft Excel 2010.
microsoft-excel microsoft-excel-2010 charts
edited Sep 24 '15 at 10:14
bertieb
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each day (i.e. on the 2nd day it'll add the amount of purchaess on the 1st and 2nd, on the 3rd it would be the amount on the 1st, 2nd, and 3rd etc) and the total amount of purchases in August 2015.
There are some low spikes on the Saturdays and Sundays.
So what I want to do is put the day name of the date on top of the bars, e.g. over the 2014 day 1 bar it would say Friday and over the 2015 day 1 bar it would say Saturday.
Is this possible?
Please note that I am using Microsoft Excel 2010.
microsoft-excel microsoft-excel-2010 charts
edited Sep 24 '15 at 10:14
bertieb
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each day (i.e. on the 2nd day it'll add the amount of purchaess on the 1st and 2nd, on the 3rd it would be the amount on the 1st, 2nd, and 3rd etc) and the total amount of purchases in August 2015.
There are some low spikes on the Saturdays and Sundays.
So what I want to do is put the day name of the date on top of the bars, e.g. over the 2014 day 1 bar it would say Friday and over the 2015 day 1 bar it would say Saturday.
Is this possible?
Please note that I am using Microsoft Excel 2010.
microsoft-excel microsoft-excel-2010 charts
microsoft-excel microsoft-excel-2010 charts
edited Sep 24 '15 at 10:14
bertieb
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
edited Sep 24 '15 at 10:14
bertieb
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
edited Sep 24 '15 at 10:14
bertieb
5,527112242
edited Sep 24 '15 at 10:14
bertieb
5,527112242
edited Sep 24 '15 at 10:14
bertieb
5,527112242
5,527112242
asked Sep 24 '15 at 9:08
Ben Smith
10612
asked Sep 24 '15 at 9:08
Ben Smith
10612
asked Sep 24 '15 at 9:08
Ben Smith
10612
10612
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You can put the text into cells in the worksheet, for example in an extra column or row adjacent to the chart source data. Next, add data labels to the series.
Select the data labels with one click, then with a second single click select a single data label. Type a = sign into the formula bar and click the cell with the text you want to use as a label. If the cell is blank, the label will be blank.
Rinse and repeat for each data label.
If you find that too tedious, download the free XY Chart Labeler add-in by Rob Bovey. It does exactly the same thing, only automated with VBA.
In Excel 2013 and higher, the data label formatting settings include a "value from cells" option natively, but they don't play well when opened with earlier Excel versions.
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
1
So are you saying to add a label, then within the label put=and then the cell that contains the date name?
– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You can put the text into cells in the worksheet, for example in an extra column or row adjacent to the chart source data. Next, add data labels to the series.
Select the data labels with one click, then with a second single click select a single data label. Type a = sign into the formula bar and click the cell with the text you want to use as a label. If the cell is blank, the label will be blank.
Rinse and repeat for each data label.
If you find that too tedious, download the free XY Chart Labeler add-in by Rob Bovey. It does exactly the same thing, only automated with VBA.
In Excel 2013 and higher, the data label formatting settings include a "value from cells" option natively, but they don't play well when opened with earlier Excel versions.
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
1
So are you saying to add a label, then within the label put=and then the cell that contains the date name?
– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
add a comment |
up vote
0
down vote
You can put the text into cells in the worksheet, for example in an extra column or row adjacent to the chart source data. Next, add data labels to the series.
Select the data labels with one click, then with a second single click select a single data label. Type a = sign into the formula bar and click the cell with the text you want to use as a label. If the cell is blank, the label will be blank.
Rinse and repeat for each data label.
If you find that too tedious, download the free XY Chart Labeler add-in by Rob Bovey. It does exactly the same thing, only automated with VBA.
In Excel 2013 and higher, the data label formatting settings include a "value from cells" option natively, but they don't play well when opened with earlier Excel versions.
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
1
So are you saying to add a label, then within the label put=and then the cell that contains the date name?
– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
add a comment |
up vote
0
down vote
up vote
0
down vote
You can put the text into cells in the worksheet, for example in an extra column or row adjacent to the chart source data. Next, add data labels to the series.
Select the data labels with one click, then with a second single click select a single data label. Type a = sign into the formula bar and click the cell with the text you want to use as a label. If the cell is blank, the label will be blank.
Rinse and repeat for each data label.
If you find that too tedious, download the free XY Chart Labeler add-in by Rob Bovey. It does exactly the same thing, only automated with VBA.
In Excel 2013 and higher, the data label formatting settings include a "value from cells" option natively, but they don't play well when opened with earlier Excel versions.
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
You can put the text into cells in the worksheet, for example in an extra column or row adjacent to the chart source data. Next, add data labels to the series.
Select the data labels with one click, then with a second single click select a single data label. Type a = sign into the formula bar and click the cell with the text you want to use as a label. If the cell is blank, the label will be blank.
Rinse and repeat for each data label.
If you find that too tedious, download the free XY Chart Labeler add-in by Rob Bovey. It does exactly the same thing, only automated with VBA.
In Excel 2013 and higher, the data label formatting settings include a "value from cells" option natively, but they don't play well when opened with earlier Excel versions.
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
answered Sep 24 '15 at 9:31
teylyn
16.6k22438
16.6k22438
1
So are you saying to add a label, then within the label put=and then the cell that contains the date name?
– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
add a comment |
1
So are you saying to add a label, then within the label put=and then the cell that contains the date name?
– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
1
1
So are you saying to add a label, then within the label put
= and then the cell that contains the date name?– Ben Smith
Sep 24 '15 at 10:39
So are you saying to add a label, then within the label put
= and then the cell that contains the date name?– Ben Smith
Sep 24 '15 at 10:39
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
Yes, like in the screenshot.
– teylyn
Sep 25 '15 at 3:19
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f977486%2fexcel-charts-is-it-possible-to-add-specific-text-to-the-bars-on-a-chart%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
