Jeff Earle
New Member
- Joined
- Jul 1, 2010
- Messages
- 14
Each row of data needs 1 chart keeping the column headers as the y axis but do not chart any column that has a zero. I have tried looking up dynamic charts but cannot get the results I want.
Here is some sample data:
Col A Col B Col C Col D Col E Col F
Driver Name Violation1 Violation2 Violation3 Violation4 Violation5
Driver1 3 0 1 2 0
Driver2 0 4 2 0 0
Driver3 1 6 0 2 3
Driver4 0 3 4 1 5
Driver5 0 0 0 0 0
Chart for Driver1 should only chart columns B, D & E only.
Chart for Driver2 should only chart columns C & D only.
Chart for Driver3 should only chart columns B, C, E & F only.
Etc for the rest.
If any of the 0 in a row is changed to a number, I want the chart to automatically update with the new column and value.
Is there a way to do this?
I will complicate this even more. The sample data above is for the 1st qtr of the year. I want to chart all 4 qtrs for each driver on the same chart with each qtr as a different colour bar under the column header. Some qtr may have violation amounts in the same column, some may not.
Any help would be appreciated.
Here is some sample data:
Col A Col B Col C Col D Col E Col F
Driver Name Violation1 Violation2 Violation3 Violation4 Violation5
Driver1 3 0 1 2 0
Driver2 0 4 2 0 0
Driver3 1 6 0 2 3
Driver4 0 3 4 1 5
Driver5 0 0 0 0 0
Chart for Driver1 should only chart columns B, D & E only.
Chart for Driver2 should only chart columns C & D only.
Chart for Driver3 should only chart columns B, C, E & F only.
Etc for the rest.
If any of the 0 in a row is changed to a number, I want the chart to automatically update with the new column and value.
Is there a way to do this?
I will complicate this even more. The sample data above is for the 1st qtr of the year. I want to chart all 4 qtrs for each driver on the same chart with each qtr as a different colour bar under the column header. Some qtr may have violation amounts in the same column, some may not.
Any help would be appreciated.
