Dynamically extended chart, horizontal data
What im asking is I believe called defined names. I have basic understanding to Excel usage and I love the software. Given in I have data that looks like this:
Date | Value A | Value B | Value C
1.1.2019 | 20 | 20 | 20
2.1.2019 | 22 | 21 | 20
3.1.2019 | 23 | 25 | 26
Im looking to create line graph that updates automatically when you enter new data rows - one graph for each value. I already tried using OFFSET and COUNTA functions with no luck. Any tips?
microsoft-excel charts
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
add a comment |
What im asking is I believe called defined names. I have basic understanding to Excel usage and I love the software. Given in I have data that looks like this:
Date | Value A | Value B | Value C
1.1.2019 | 20 | 20 | 20
2.1.2019 | 22 | 21 | 20
3.1.2019 | 23 | 25 | 26
Im looking to create line graph that updates automatically when you enter new data rows - one graph for each value. I already tried using OFFSET and COUNTA functions with no luck. Any tips?
microsoft-excel charts
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49
add a comment |
What im asking is I believe called defined names. I have basic understanding to Excel usage and I love the software. Given in I have data that looks like this:
Date | Value A | Value B | Value C
1.1.2019 | 20 | 20 | 20
2.1.2019 | 22 | 21 | 20
3.1.2019 | 23 | 25 | 26
Im looking to create line graph that updates automatically when you enter new data rows - one graph for each value. I already tried using OFFSET and COUNTA functions with no luck. Any tips?
microsoft-excel charts
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
What im asking is I believe called defined names. I have basic understanding to Excel usage and I love the software. Given in I have data that looks like this:
Date | Value A | Value B | Value C
1.1.2019 | 20 | 20 | 20
2.1.2019 | 22 | 21 | 20
3.1.2019 | 23 | 25 | 26
Im looking to create line graph that updates automatically when you enter new data rows - one graph for each value. I already tried using OFFSET and COUNTA functions with no luck. Any tips?
microsoft-excel charts
microsoft-excel charts
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
asked Jan 25 at 18:03
ijo2o35g2ijo2o35g2
62
62
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49
add a comment |
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49
add a comment |
1 Answer
1
active
oldest
votes
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
- Turn the data structure to formatted table
- Base the line graph on the formatted table
- Chart data range will automatically change when the formatted table is expanded
- Since formatted data table and chart data range is modified, the line graph is also drawn again
(However, note that removing rows from data does not trigger correct line graph ranges)
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
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
});
}
});
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%2f1398501%2fdynamically-extended-chart-horizontal-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
- Turn the data structure to formatted table
- Base the line graph on the formatted table
- Chart data range will automatically change when the formatted table is expanded
- Since formatted data table and chart data range is modified, the line graph is also drawn again
(However, note that removing rows from data does not trigger correct line graph ranges)
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
add a comment |
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
- Turn the data structure to formatted table
- Base the line graph on the formatted table
- Chart data range will automatically change when the formatted table is expanded
- Since formatted data table and chart data range is modified, the line graph is also drawn again
(However, note that removing rows from data does not trigger correct line graph ranges)
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
add a comment |
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
- Turn the data structure to formatted table
- Base the line graph on the formatted table
- Chart data range will automatically change when the formatted table is expanded
- Since formatted data table and chart data range is modified, the line graph is also drawn again
(However, note that removing rows from data does not trigger correct line graph ranges)
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
- Turn the data structure to formatted table
- Base the line graph on the formatted table
- Chart data range will automatically change when the formatted table is expanded
- Since formatted data table and chart data range is modified, the line graph is also drawn again
(However, note that removing rows from data does not trigger correct line graph ranges)
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
answered Jan 25 at 19:05
ijo2o35g2ijo2o35g2
62
62
add a comment |
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.
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%2f1398501%2fdynamically-extended-chart-horizontal-data%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
Try looking into PivotCharts
– Eric F
Jan 25 at 18:08
See if this helps: superuser.com/questions/1361797/…
– Rey Juna
Jan 25 at 18:40
Possible duplicate of How to define a graph, based on automatically changing data?
– fixer1234
Jan 25 at 22:49