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.