| 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. |
| 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)
Hybrid Mode
