| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel column chart with a 2ndary y axis w/o bars overplotting?
How do you create a column chart with a secondary axis without having the
bars overplotting? I would like the bars to be adjacent to one another. |
|
#2
|
|||
|
|||
|
This example should help:
http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
Your URL does not go to the example. Do you have another?
All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
John's site has mysteriously disappeared.
Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
Thanks for making my day better!
Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
Have a look here for explanation, including pictures.
http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Christine Dam Bendiksen" wrote in message ... Thanks for making my day better! Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
This post was very useful, thanks! I have another related question, though.
How can you delete the dummy data legends if you're using the "Data Table" option in the "Chart Options..." menu? "Andy Pope" wrote: Have a look here for explanation, including pictures. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Christine Dam Bendiksen" wrote in message ... Thanks for making my day better! Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
You should use an alternative for the data table. Make a table in the
worksheet adjacent to your chart, or make the table elsewhere, select and copy it, and use Edit menu Paste Picture Link to paste a linked image of the table on or near the chart.. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Antonio" wrote in message ... This post was very useful, thanks! I have another related question, though. How can you delete the dummy data legends if you're using the "Data Table" option in the "Chart Options..." menu? "Andy Pope" wrote: Have a look here for explanation, including pictures. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Christine Dam Bendiksen" wrote in message ... Thanks for making my day better! Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
Thanks, Jon. The file I'm creating is for a template, so the data will be
changing constantly. Do you know if there is any other solution that would allow the data table to change if the chart data changes? "Jon Peltier" wrote: You should use an alternative for the data table. Make a table in the worksheet adjacent to your chart, or make the table elsewhere, select and copy it, and use Edit menu Paste Picture Link to paste a linked image of the table on or near the chart.. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Antonio" wrote in message ... This post was very useful, thanks! I have another related question, though. How can you delete the dummy data legends if you're using the "Data Table" option in the "Chart Options..." menu? "Andy Pope" wrote: Have a look here for explanation, including pictures. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Christine Dam Bendiksen" wrote in message ... Thanks for making my day better! Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel column chart with a 2ndary y axis w/o bars overplotting?
Paste Picture Link. I just tested it using a dynamic range for the link.
Here is a name I defined: Name: MyRange Refers To: =OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B:$B),COUNT A(Sheet1!$3:$3)) I copied the range B3:D5, held down Shift while clicking on the Edit menu, and selected Paste Picture Link. With the picture selected, the formula bar contained this link: =$B$3:$D$5 I changed this to: =MyRange and as I changed the size of MyRange, the size of the linked picture automatically adjusted to include all of MyRange. So set up the copied range and the associated dynamic name, and paste a linked picture of it by your chart. If you paste it onto a chart sheet, it doesn't seem to allow linking, but you can select the picture, type the link above into the formula bar, and press Enter, and it's just what you needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Antonio" wrote in message ... Thanks, Jon. The file I'm creating is for a template, so the data will be changing constantly. Do you know if there is any other solution that would allow the data table to change if the chart data changes? "Jon Peltier" wrote: You should use an alternative for the data table. Make a table in the worksheet adjacent to your chart, or make the table elsewhere, select and copy it, and use Edit menu Paste Picture Link to paste a linked image of the table on or near the chart.. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Antonio" wrote in message ... This post was very useful, thanks! I have another related question, though. How can you delete the dummy data legends if you're using the "Data Table" option in the "Chart Options..." menu? "Andy Pope" wrote: Have a look here for explanation, including pictures. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Christine Dam Bendiksen" wrote in message ... Thanks for making my day better! Just a final question...I can't find a way to delete the unwanted legend entries, as don't know how to select them.... my excell is i danish, so I have to translate, but can you tell me exactly how to do it, you know, in baby-steps?? ;-)) Christine "Jon Peltier" skrev: John's site has mysteriously disappeared. Try this: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "dguilbault" wrote in message ... Your URL does not go to the example. Do you have another? All I see is a picture of a flower there. "John Mansfield" wrote: This example should help: http://www.pdbook.com/index.php/exce...with_two_axes/ -- Regards, John Mansfield http://www.pdbook.com -- Regards, John Mansfield http://www.pdbook.com "LAdams@work" wrote: How do you create a column chart with a secondary axis without having the bars overplotting? I would like the bars to be adjacent to one another. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| The best method for forumlas and charts??? | Excel Discussion (Misc queries) | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
| Combine candle and line in a single chart | Charts and Charting in Excel | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
![Christine Dam Bendiksen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
