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.