Resizing Excel 2010 graphs

[nevica]

Hello,

I create an excel 2010 graph (scatter plot, lines) from 4 or data sets.

The graph is drawn.

I then re-size the axis by right clicking on the axis and then format axis to define the limits. I make them smaller. What I find is that sometimes some of the data sets disappear even though the data should be in view.

The same also happens if I resize the graph by toggling on the corner of the graph pane and physically resizing. This seems to be a bug within Microsoft excel itself and totally defeats the idea of graphing software if one cannot zoom into specific parts of a graph.

Is there any way around this bug please.

Thanks,

Nevica

[XOR LX]

Hi,

Which source informed you that the way to zoom in to an Excel chart was via re-sizing (either the whole chart or the axes)?

Have you tried simply zooming in (alt+V+Z or go to View→Zoom?)

Regards

[nevica]

This is not what I want to do. I want to change the limits on each of the axes. What you are explaining is something different.

You are right in saying that your method does not make the data disappear but that is not what I want to do.

Nevica

[XOR LX]

Ah, then my apologies. If you are looking for this ability to zoom in to e.g. one of the axes and have that axis' scale automatically re-calibrated then yes, I'm afraid you won't find that feature in Excel, at least in 2010 and below.