A
Alex Delamain
I have a number of large spreadsheets used for analysing quality data
On each table there are several trend charts showing results over time
On each chart I have also added control limits set up as XY ranges.
Initially all worked well.....but..... for some reason when I filte
the lists now (to select specific products) the x axis labels (set u
as a named range) expand to fill most of the graph space.
Without the XY ranges it all works fine but with them in place i
doesnt. When I check the axis format I also find that I can no longe
change the number of categories between tick marks.
What am I doing wrong
On each table there are several trend charts showing results over time
On each chart I have also added control limits set up as XY ranges.
Initially all worked well.....but..... for some reason when I filte
the lists now (to select specific products) the x axis labels (set u
as a named range) expand to fill most of the graph space.
Without the XY ranges it all works fine but with them in place i
doesnt. When I check the axis format I also find that I can no longe
change the number of categories between tick marks.
What am I doing wrong