how can I make different charts the same size?

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I need a scientific poster, and I need to present my results. I want the
graphs to have the same size and format. I know I can do this one by one,
but I would like to know if I can do it with a specific comand to keep the
same style and size of each chart.

Thanks!!!
 
When you hold Alt while dragging and resizing charts on a worksheet, the
edges of the chart stick to cell boundaries. Simply align one chart within a
particular range of cells, then resize all charts to this range, or a range
that is sized the same.

To get the formatting the same, select the chart area of one chart and copy
it, then select another chart, and use paste special to paste the formats
from the first chart onto the second. Repeat for all of your other charts.

Note, not only are formats copies, but so are the text contents of chart and
axis titles, data labels, etc.

- Jon
 
Back
Top