How to customize line charts in Excel The Next CEO of Stack OverflowGraphing by time in...
Does Germany produce more waste than the US?
How to get from Geneva Airport to Metabief, Doubs, France by public transport?
Is micro rebar a better way to reinforce concrete than rebar?
A Man With a Stainless Steel Endoskeleton (like The Terminator) Fighting Cloaked Aliens Only He Can See
Unclear about dynamic binding
Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
How to invert MapIndexed on a ragged structure? How to construct a tree from rules?
Is the D&D universe the same as the Forgotten Realms universe?
Is it possible to replace duplicates of a character with one character using tr
Why didn't Khan get resurrected in the Genesis Explosion?
Can MTA send mail via a relay without being told so?
0 rank tensor vs 1D vector
Won the lottery - how do I keep the money?
Why isn't the Mueller report being released completely and unredacted?
How to write a definition with variants?
The exact meaning of 'Mom made me a sandwich'
Method for adding error messages to a dictionary given a key
Make solar eclipses exceedingly rare, but still have new moons
Can this equation be simplified further?
Running a General Election and the European Elections together
Chain wire methods together in Lightning Web Components
Why does standard notation not preserve intervals (visually)
What steps are necessary to read a Modern SSD in Medieval Europe?
How to customize line charts in Excel
The Next CEO of Stack OverflowGraphing by time in ExcelHow to generate Excel charts show per interval?How to calculate area between graph line and average line?Set up Excel 2013 charts with distinct line colours and fonts as in Excel 2003Modifying Column Charts in ExcelExcel X axis on chartsExcel Charts - Single point series with target lineShowing multiple series with the same data in excel chartsChart options missing in excel 2016Excel Charts Showing Blank and with Data as Header
In an Excel line chart, how do you do the following (if it can be done):
- have different colours within the line,
- insert an arrow pointing to an area of the line with a caption
with text explaining what it is referring to?
microsoft-excel charts office365 microsoft-excel-365
edited 13 mins ago
Scott
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In an Excel line chart, how do you do the following (if it can be done):
- have different colours within the line,
- insert an arrow pointing to an area of the line with a caption
with text explaining what it is referring to?
microsoft-excel charts office365 microsoft-excel-365
edited 13 mins ago
Scott
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In an Excel line chart, how do you do the following (if it can be done):
- have different colours within the line,
- insert an arrow pointing to an area of the line with a caption
with text explaining what it is referring to?
microsoft-excel charts office365 microsoft-excel-365
edited 13 mins ago
Scott
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
In an Excel line chart, how do you do the following (if it can be done):
- have different colours within the line,
- insert an arrow pointing to an area of the line with a caption
with text explaining what it is referring to?
microsoft-excel charts office365 microsoft-excel-365
microsoft-excel charts office365 microsoft-excel-365
edited 13 mins ago
Scott
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 mins ago
Scott
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 mins ago
Scott
16.1k113990
edited 13 mins ago
Scott
16.1k113990
edited 13 mins ago
Scott
16.1k113990
16.1k113990
asked yesterday
MurrayMurray
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
MurrayMurray
12
asked yesterday
MurrayMurray
12
12
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Murray is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
A somewhat brute force way to have different colors
within a line in a line chart
is simply to break the data into multiple lines.
For example, given these data:
we can set
- C1
=IF(ROW()<=3, A1, #N/A)
- D1
=IF(AND(ROW()>=3,ROW()<=4), A1, #N/A)
- E1
=IF(ROW()>=4, A1, #N/A)
and get this chart:
There may be similar tricks,
involving overlaying multiple charts on the same area,
to get other effects, but, offhand, I don’t know of any easy ones.
answered 8 hours ago
ScottScott
16.1k113990
add a comment |
You cannot do any of the two things you want.
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Murray is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1419219%2fhow-to-customize-line-charts-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
A somewhat brute force way to have different colors
within a line in a line chart
is simply to break the data into multiple lines.
For example, given these data:
we can set
- C1
=IF(ROW()<=3, A1, #N/A)
- D1
=IF(AND(ROW()>=3,ROW()<=4), A1, #N/A)
- E1
=IF(ROW()>=4, A1, #N/A)
and get this chart:
There may be similar tricks,
involving overlaying multiple charts on the same area,
to get other effects, but, offhand, I don’t know of any easy ones.
answered 8 hours ago
ScottScott
16.1k113990
add a comment |
A somewhat brute force way to have different colors
within a line in a line chart
is simply to break the data into multiple lines.
For example, given these data:
we can set
- C1
=IF(ROW()<=3, A1, #N/A)
- D1
=IF(AND(ROW()>=3,ROW()<=4), A1, #N/A)
- E1
=IF(ROW()>=4, A1, #N/A)
and get this chart:
There may be similar tricks,
involving overlaying multiple charts on the same area,
to get other effects, but, offhand, I don’t know of any easy ones.
answered 8 hours ago
ScottScott
16.1k113990
add a comment |
A somewhat brute force way to have different colors
within a line in a line chart
is simply to break the data into multiple lines.
For example, given these data:
we can set
- C1
=IF(ROW()<=3, A1, #N/A)
- D1
=IF(AND(ROW()>=3,ROW()<=4), A1, #N/A)
- E1
=IF(ROW()>=4, A1, #N/A)
and get this chart:
There may be similar tricks,
involving overlaying multiple charts on the same area,
to get other effects, but, offhand, I don’t know of any easy ones.
answered 8 hours ago
ScottScott
16.1k113990
A somewhat brute force way to have different colors
within a line in a line chart
is simply to break the data into multiple lines.
For example, given these data:
we can set
- C1
=IF(ROW()<=3, A1, #N/A)
- D1
=IF(AND(ROW()>=3,ROW()<=4), A1, #N/A)
- E1
=IF(ROW()>=4, A1, #N/A)
and get this chart:
There may be similar tricks,
involving overlaying multiple charts on the same area,
to get other effects, but, offhand, I don’t know of any easy ones.
answered 8 hours ago
ScottScott
16.1k113990
answered 8 hours ago
ScottScott
16.1k113990
answered 8 hours ago
ScottScott
16.1k113990
answered 8 hours ago
ScottScott
16.1k113990
16.1k113990
add a comment |
add a comment |
You cannot do any of the two things you want.
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
add a comment |
You cannot do any of the two things you want.
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
add a comment |
You cannot do any of the two things you want.
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
You cannot do any of the two things you want.
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
answered 20 hours ago
Bogdan DoicinBogdan Doicin
650615
650615
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
add a comment |
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
1
1
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
While saying you can't do what you ask is a valid answer, it's necessary to offer a bit of explanation. Further, you're wrong about not being able to do these things, so you'll need to justify your claim.
– Twisty Impersonator
16 hours ago
add a comment |
Murray is a new contributor. Be nice, and check out our Code of Conduct.
Murray is a new contributor. Be nice, and check out our Code of Conduct.
Murray is a new contributor. Be nice, and check out our Code of Conduct.
Murray is a new contributor. Be nice, and check out our Code of Conduct.
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.
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%2f1419219%2fhow-to-customize-line-charts-in-excel%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
