How do I get my sizing handles back? Graph/data on same page.

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I created a simple line graph on the same page as the data. The blue sizing
handles use to be present when I wanted to add data, but now the handles are
no longer present and I have to go through the longer way of adding data by
using the Chart source data option. Is there a way to get the sizing handles
back?
 
If you have added any series "the long way", amended the formula for any
series or for any reason have an input range Excel considers to be
non-simple, it won't show the coloured range areas.

If your chart really is simple and based on a single contiguous range,
simply replace the chart data range completlely and let it be rebuilt.
(Select data > in the first box for Chart data range, use the refedit
button to go select your range including all your headers, then OK and
let Excel figure it out from scratch).

Hope this helps
Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph Line Width ? 1
Excel chokes when printing multiple charts per page 2
Display Data Table in chart but don't show plot area 2
Excel graphs change when pasted into Publisher - Metafiles change? 0
Adding Additional Points to a Line Chart 7
Suppres Zero or empty Cell value in a line graph 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
how can I make different charts the same size? 1

Back
Top