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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Your URL does not go to the example. Do you have another?
All I see is a picture of a flower there.
 
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:
 
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?
 
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
 
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?
 
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 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
 
Back
Top