Excel column chart with a 2ndary y axis w/o bars overplotting?

[LAdams@work]

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.

 

[John Mansfield]

This example should help:

http://www.pdbook.com/index.php/excel/two_column_series_with_two_axes/

--
Regards,
John Mansfield
http://www.pdbook.com

 

[dguilbault]

Your URL does not go to the example. Do you have another?
All I see is a picture of a flower there.

 

[Jon Peltier]

John's site has mysteriously disappeared.

Try this:
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.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
_______

 

[Christine Dam Bendiksen]

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:

 

[Andy Pope]

Have a look here for explanation, including pictures.
http://www.andypope.info/charts/deletelegendentry.htm

Cheers
Andy

 

[Antonio]

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?

 

[Jon Peltier]

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

 

[Antonio]

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]

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),COUNTA(Sheet1!$3:$3))

I copied the range B35, 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