View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Line - Column Charts

Example
A B C
data a data b
Monday 34
Tuesday 56
Wednesday 45
Thursday 40
Friday 50
Saturday 60
Sunday 70
Make a column chart by selecting A1:C8
Right click on a data b bar in cart; use Chart Type from popup menu, specify
Line
Hope this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DJ Runt" <DJ wrote in message
...
I am using line-column charts to show productivity metrics. The columns
(bars) are indicators and the line as a benchmark. After 5 indicators,
the
bars change to data poitns. Is there a way to have multiple bars
(columns)?