Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Need a custom chart with 2 vertical bars side by side, on one axis, and a
line on a second axis. Anyone know the series of steps I need? I was having trouble figuring out the order of what set of the three data goes where, and how to define which of the pieces is on bar and which is on line, and which is second axis, etc. Thanks for any help. -- Boris |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Hi,
Create your own combination chart by starting with a clustered column chart. Then right click the column series you wish to change to a line. From the context menu pick Chart Type. Choose the appropriate line chart. Cheers Andy BorisS wrote: Need a custom chart with 2 vertical bars side by side, on one axis, and a line on a second axis. Anyone know the series of steps I need? I was having trouble figuring out the order of what set of the three data goes where, and how to define which of the pieces is on bar and which is on line, and which is second axis, etc. Thanks for any help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Thanks. And how do I get the second axis to work? In other words, by
clicking on the series which I want to convert from column to line, do I select the custom column-line 2 axes type, and then it knows automatically that I meant for the column on which I selected to be the line and the second axis? Thanks for the further clarification. -- Boris "Andy Pope" wrote: Hi, Create your own combination chart by starting with a clustered column chart. Then right click the column series you wish to change to a line. From the context menu pick Chart Type. Choose the appropriate line chart. Cheers Andy BorisS wrote: Need a custom chart with 2 vertical bars side by side, on one axis, and a line on a second axis. Anyone know the series of steps I need? I was having trouble figuring out the order of what set of the three data goes where, and how to define which of the pieces is on bar and which is on line, and which is second axis, etc. Thanks for any help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
If you double click the series there is an tab on the format dialog
which allows you to specify which axis to use. The secondary y axis is displayed automatically. If you need the secondary X axis see here http://www.andypope.info/tips/tip008.htm Cheers Andy BorisS wrote: Thanks. And how do I get the second axis to work? In other words, by clicking on the series which I want to convert from column to line, do I select the custom column-line 2 axes type, and then it knows automatically that I meant for the column on which I selected to be the line and the second axis? Thanks for the further clarification. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Very impressive stuff on your site. Hats off. I've seen some others, but
this is a cut above. Thanks for the tips on selecting secondary axis as well. Not sure if it's a related question, but actually choosing which type of charting happens for a particular series (as in, if I have, let's say, three lines that I want and 2 bars). Possible? How do I tell Excel which series goes with which type, or is it simply that if I have two axes, and one corresponds to columns and the other to lines, then by telling something that is initially a column to be on the secondary axis, it'll just switch to a line because it'll then be on the secondary axis? -- Boris "Andy Pope" wrote: If you double click the series there is an tab on the format dialog which allows you to specify which axis to use. The secondary y axis is displayed automatically. If you need the secondary X axis see here http://www.andypope.info/tips/tip008.htm Cheers Andy BorisS wrote: Thanks. And how do I get the second axis to work? In other words, by clicking on the series which I want to convert from column to line, do I select the custom column-line 2 axes type, and then it knows automatically that I meant for the column on which I selected to be the line and the second axis? Thanks for the further clarification. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Firstly, thanks for the comments.
With column and line it is possible to have both chart types on both sets of axes. So you will need to change both the chart and axis type of the series. Cheers Andy BorisS wrote: Very impressive stuff on your site. Hats off. I've seen some others, but this is a cut above. Thanks for the tips on selecting secondary axis as well. Not sure if it's a related question, but actually choosing which type of charting happens for a particular series (as in, if I have, let's say, three lines that I want and 2 bars). Possible? How do I tell Excel which series goes with which type, or is it simply that if I have two axes, and one corresponds to columns and the other to lines, then by telling something that is initially a column to be on the secondary axis, it'll just switch to a line because it'll then be on the secondary axis? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
so in now rereading your initial response, you're saying that I don't even
have to pick the custom charts when selecting to change each column? I can literally pick each column and say that I want it to be a line, and Excel will keep the other columns intact? -- Boris "Andy Pope" wrote: Firstly, thanks for the comments. With column and line it is possible to have both chart types on both sets of axes. So you will need to change both the chart and axis type of the series. Cheers Andy BorisS wrote: Very impressive stuff on your site. Hats off. I've seen some others, but this is a cut above. Thanks for the tips on selecting secondary axis as well. Not sure if it's a related question, but actually choosing which type of charting happens for a particular series (as in, if I have, let's say, three lines that I want and 2 bars). Possible? How do I tell Excel which series goes with which type, or is it simply that if I have two axes, and one corresponds to columns and the other to lines, then by telling something that is initially a column to be on the secondary axis, it'll just switch to a line because it'll then be on the secondary axis? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
two bars and a line on 2 axes
Yep.
BorisS wrote: so in now rereading your initial response, you're saying that I don't even have to pick the custom charts when selecting to change each column? I can literally pick each column and say that I want it to be a line, and Excel will keep the other columns intact? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overlapping Bars Chart & Two Y Axes: how? | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
How do I graph 2 bars with 2 different axes? | Charts and Charting in Excel | |||
How to display chart with three bars and one line? | Charts and Charting in Excel | |||
Removing overlap of bars when 2 Y axes are used | Charts and Charting in Excel |