ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line - Column Charts (https://www.excelbanter.com/charts-charting-excel/62380-line-column-charts.html)

DJ Runt

Line - Column Charts
 
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)?

Bernard Liengme

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)?





All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com