In article ,
says...
Hello all,

I created a Bar and Line Charts by using the technique of combining a bar
and XY scatter plot. (I refer to
http://peltiertech.com/Excel/Charts/BarLineCombo.html)

However, I also need a data table which shows the value. Anyway to do it?

Thanks,
Kaci

To create a Bar chart in combination with a Line chart (rather than a XY
Scatter chart), simply add all the series you want as a bar chart. Then,
select each and change the chart type with Chart | Chart Type...

As far as a data table goes, XL's capabilities are very limited. You will
be better off simulating the effect. See
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions