Excel Pivot Chart 'fixed' horizontal axis
I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.
I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for example.
Thing is, the axis options do not show bounds to set as I have found to appear in other solutions:
I've double checked to make sure my axis data is formated as numbers:
In case of possible relevancy, the formula used to calculate the day time indicator is
=mround((mod(GDQ[Timestamp];1)*24);0,5)
Is there a way to have the horizontal axis always show start through end plotting the filtered data always on the same timeframe?
excel powerpivot axis-labels pivot-chart
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
add a comment |
I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.
I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for example.
Thing is, the axis options do not show bounds to set as I have found to appear in other solutions:
I've double checked to make sure my axis data is formated as numbers:
In case of possible relevancy, the formula used to calculate the day time indicator is
=mround((mod(GDQ[Timestamp];1)*24);0,5)
Is there a way to have the horizontal axis always show start through end plotting the filtered data always on the same timeframe?
excel powerpivot axis-labels pivot-chart
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19
add a comment |
I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.
I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for example.
Thing is, the axis options do not show bounds to set as I have found to appear in other solutions:
I've double checked to make sure my axis data is formated as numbers:
In case of possible relevancy, the formula used to calculate the day time indicator is
=mround((mod(GDQ[Timestamp];1)*24);0,5)
Is there a way to have the horizontal axis always show start through end plotting the filtered data always on the same timeframe?
excel powerpivot axis-labels pivot-chart
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.
I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for example.
Thing is, the axis options do not show bounds to set as I have found to appear in other solutions:
I've double checked to make sure my axis data is formated as numbers:
In case of possible relevancy, the formula used to calculate the day time indicator is
=mround((mod(GDQ[Timestamp];1)*24);0,5)
Is there a way to have the horizontal axis always show start through end plotting the filtered data always on the same timeframe?
excel powerpivot axis-labels pivot-chart
excel powerpivot axis-labels pivot-chart
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
asked Nov 15 '18 at 16:58
Bart de BrouwerBart de Brouwer
214
214
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19
add a comment |
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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%2fstackoverflow.com%2fquestions%2f53324441%2fexcel-pivot-chart-fixed-horizontal-axis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53324441%2fexcel-pivot-chart-fixed-horizontal-axis%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
I'm gonna take a shot here and say that it can't be done, as the x axis data points are categorical in nature - I don't see any option to set a min/max for those points in Excel 2016, but I could be totally wrong.
– dwirony
Nov 15 '18 at 17:12
But even then, there should be an option to fixed set of categories I can fill in, not?
– Bart de Brouwer
Nov 15 '18 at 19:22
I'm not sure what you mean, "to fixed set of categories I can fill in"?
– dwirony
Nov 15 '18 at 19:46
If I cannot trick Excel into setting a minnmax range for the numbers to display, can I enter a set to always display along the axis? So instead of mine 7,5 max 18, I would just enter my intervals as categories for it to plot against?
– Bart de Brouwer
Nov 15 '18 at 22:19