View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Dave Curtis Dave Curtis is offline
external usenet poster
 
Posts: 100
Default Secondary Axis Values Disappear

Hi Karen,

Excel's chart data tables have many limitations. It depends what type of
chart you have. Some types won't let you have a data table at all, some only
for data on one axis. Some, like a column chart, will let you have a data
table even if you have both primarty and secondary axes. If you have a
combination chart, well, forget it!
They also have very limited formatting and editing options.
The best way is to build your own data table in the cells below the chart,
and make it appear as though the two are connected.

Dave

url:http://www.ureader.com/msg/10296168.aspx