Hi all, i have attached a small sample of my data that I want including on my Pivot Chart.
From the attached you will see that each bar has a particular coulour relating to the shift pattern against which a particular FM is recorded.
On the secondary axis you will see lines relating to the secondary axis but these are also coloured and not continuous.
My problem is that I want to display this line continuously and independant of shift/FM etc. In other words, the line should simply show the volume/day. I my example the volume appeas to be related to FM hence the gaps between the colured lines....
Can you help??
Bookmarks