multiple similar charts

  • Thread starter Thread starter Terry A. Austin
  • Start date Start date
T

Terry A. Austin

Hi folks...

I've got a data set that I need a large series of similar, interrelated
charts from and am looking for a way to automate these. They are for my
doctoral dissertation data so are an absolute must to get done but are
incredibly tedious to set up...

Any suggestions are appreciated.


Column A = Day# and is needed in EVERY chart as X axis label

Columns B - S are various series and each needs its own chart

Finally, each tends to create its own Y axis range based on data actually in
the series but I need them all to match so charts are comparable.

Ideas???

Many thanks!

Terry
 
1) create the first chart manually.
2) on the chart, select axe Y, right-click - you'll see "format axis" menu.
In format axis, go to the tab "Scale" and deselect Auto values. Put your
own values for the max, min units, intersect etc. This will force all clone
charts look the same
3) Do other formatting to make your chart look the way you want.

Now, copy your chart and paste it as many times as you want. Then, go one by
one and change data source for Y values (to do so, select the chart, right
click, choose "Source data", then select tab "Series". On the right, replace
Values source with a new series you want to display. Don't touch X values,
they are the same for all charts)

This sounds like a lot of work, but it's actually very fast after you do it
once. Otherwise, you'll have to write VBA code.

Best -
RADO
 
Terry A. Austin said:
Hi folks...

I've got a data set that I need a large series of similar, interrelated
charts from and am looking for a way to automate these. They are for my
doctoral dissertation data so are an absolute must to get done but are
incredibly tedious to set up...

Any suggestions are appreciated.
Many thanks!
Terry
Click to expand...


Hello Terry,

Have thought to create a template ?

A second way would be to have a mothersheet where you have your basic
Diagram (in the way as RADO told you, with all the desired formattings) and
each time you need a new issue, export it to your new workbook with a
right click on the original sheet-tab / move/copy + copy / to your new sheet
and change only the y-values.

If by accident you changed in a non intended way your graph, look at the VBA
routine which Jon Peltier posted recently in this NG: (Google / Groups) +


or other sites allowing to scale your Diagrams such as:

http://j-walk.com/ss JWalk Chart Tools


best regards

Jean
 
Back
Top