If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 questions
I have two Excel charting questions:
1. Can you make the x axis display on the right side of the chart instead of the left? (and no, the "...crosses at maximum value" checkbox does not make it do this) 2. Can you create an overlay chart with an additional axis with both data series being instacked bar format? I can create on with stacked bar and line, but not two stacked bar ones...they just stack on top instead of being two seperate ones. |
#2
|
|||
|
|||
2 questions
1. Can you make the x axis display on the right side of the chart instead of the left? (and no, the "...crosses at maximum value" checkbox does not make it do this) What does "crosses at maximum" do? To move a vertical axis from one side to the other, you must double click the horizontal axis and choose a value for the vertical axis to cross at. 2. Can you create an overlay chart with an additional axis with both data series being instacked bar format? I can create on with stacked bar and line, but not two stacked bar ones...they just stack on top instead of being two seperate ones. You might be asking about this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#3
|
|||
|
|||
2 questions
I don't understand what you mean by choosing a value for the axis. All I
want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. "Jon Peltier" wrote: 1. Can you make the x axis display on the right side of the chart instead of the left? (and no, the "...crosses at maximum value" checkbox does not make it do this) What does "crosses at maximum" do? To move a vertical axis from one side to the other, you must double click the horizontal axis and choose a value for the vertical axis to cross at. 2. Can you create an overlay chart with an additional axis with both data series being instacked bar format? I can create on with stacked bar and line, but not two stacked bar ones...they just stack on top instead of being two seperate ones. You might be asking about this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#4
|
|||
|
|||
2 questions
I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#5
|
|||
|
|||
2 questions
When I checked that box, nothing moved. I was trying to get the scale to
move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#6
|
|||
|
|||
2 questions
He's given you the right instructions.
are you sure that you're using the right axis? Sally Sibthorpe wrote: When I checked that box, nothing moved. I was trying to get the scale to move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#7
|
|||
|
|||
2 questions
I want to move the one that is on the left to the right side of the chart.
The bottom one I want to stay put where it is. "klass" wrote: He's given you the right instructions. are you sure that you're using the right axis? Sally Sibthorpe wrote: When I checked that box, nothing moved. I was trying to get the scale to move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#8
|
|||
|
|||
2 questions
So double click the bottom axis and check the Crosses at Maximum box on the
Scale tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Sally Sibthorpe" wrote in message ... I want to move the one that is on the left to the right side of the chart. The bottom one I want to stay put where it is. "klass" wrote: He's given you the right instructions. are you sure that you're using the right axis? Sally Sibthorpe wrote: When I checked that box, nothing moved. I was trying to get the scale to move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#9
|
|||
|
|||
2 questions
Hi Sally -
Don't worry, I've had bosses like that. In fact, the last boss I had was such a nightmare, he was pathologically stupid. He then got a job with one of our suppliers, a hopeless crew, and the word was that when he left, the average IQ at both companies went up. Anyway, now I'm the boss, so there are no stupid decisions around here, at least none I can't fix. I don't understand how you're stacking two different data types together. If the data are not compatible, you will never get them to stack. The only thing I can think of is that you have dollars stacked on dollars, and next to it people stacked on people. You might want to combine these approaches: http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Sally Sibthorpe" wrote in message ... When I checked that box, nothing moved. I was trying to get the scale to move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
#10
|
|||
|
|||
2 questions
Hi Sally:
Frankly this thread confuses me a lot. Could it be that yr boss said something like "make a chart with a right axis?". Maybe he meant to ADD a right axis. This wld make sense to me, the left axis for the dollars, the right one for the people. You can have yr two columns or lines w/ a common x-axis, using different colours, etc. Whatever, such chart wld bring across the message I think. Could this change of tack help you out of the woods? HTH, Henk "Jon Peltier" wrote: Hi Sally - Don't worry, I've had bosses like that. In fact, the last boss I had was such a nightmare, he was pathologically stupid. He then got a job with one of our suppliers, a hopeless crew, and the word was that when he left, the average IQ at both companies went up. Anyway, now I'm the boss, so there are no stupid decisions around here, at least none I can't fix. I don't understand how you're stacking two different data types together. If the data are not compatible, you will never get them to stack. The only thing I can think of is that you have dollars stacked on dollars, and next to it people stacked on people. You might want to combine these approaches: http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Sally Sibthorpe" wrote in message ... When I checked that box, nothing moved. I was trying to get the scale to move to the left, so I could lay one chart on top of another and be able to see both scales. This was an alternative to the stacked chart on two axis that I was working with below. Regarding the stacked charts, I am plotting two different kinds of data. One is dollars, and the other is numbers of people, and both are over 5 years time. The need to have seperate scales because you can't compare money with people and have it make any sense. Please note...this idiotic chart is my boss' idea, not mine. "Jon Peltier" wrote: I don't understand what you mean by choosing a value for the axis. All I want is to display it on the other side, and not change anything else. In much older versions of Excel, you used to be able to just drag the info from the left axis to the right, but that doesn't work anymore. Dragging an axis from side to side of a chart was never possible in any version of Excel I've ever used (starting in about Excel 2). If you want the Y axis on the opposite side of the chart, double click the X axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I don't know why this didn't work for you. And no, your link did not show what I am trying to do. I want stacked column chart desplayed on two axis...you know...the columns are striped horizontally with the different data. The examples in your link were either bar or column charts, but they weren't stacked. How does a stacked chart refer to different axes? Each item in the stack has to be plotted against the same scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | New Users | 4 | June 28th, 2004 02:58 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Formatting Long Documents | 4 | June 28th, 2004 02:57 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Mailmerge | 6 | June 28th, 2004 02:57 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - May | Charles Kenyon | Mailmerge | 3 | May 24th, 2004 05:54 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - April | Charles Kenyon | Mailmerge | 0 | April 26th, 2004 03:33 PM |