Chart layout problem

[NickTheBatMan]

I want to make my chart display the full width of the page, but just
above where the Legend is shown - I know how to remove that - there's
a blue box "Drop Series Fields Here" that I can't find how to
remove !

Any simple pointers - I am no good at all with VBA and we're not able
to install anything complex at work - very gratefully received

Nick in Leeds

 

[NickTheBatMan]

I want to make my chart display the full width of the page, but just
above where the Legend is shown - I know how to remove that - there's
a blue box "Drop Series Fields Here" that I can't find how to
remove !

Any simple pointers - I am no good at all with VBA and we're not able
to install anything complex at work - very gratefully received

Nick in Leeds

Another question someone may be able to help with...

Anyone know how I can specify the hight of a chart ?

I've created 2 from the same table and one of them takes up half the
page which shows the text below as a nice single line, and the other
the chart takes up most of the page and the text is all squashed up
below !

The scales are massively different - the smaller chart is 100s and the
big one is 1000s - due to the data returned and I'm displaying them as
100s & 1000s respectfully so that they end up a max of 25 & 18
respectfully...

I want the hight of the two charts to be the same - half the hight of
the page - so that the Catagory axis text displays properly...

Any pointers gratefully recieved