MAKING A GRAPH WITH A MACRO.

[GRAPH WITH A MACRO]

i have a to make many graphs, so is there any macro to run & graphs made easy
for many graphs with one macro. i have to change the numbers for each graph,
but the macro you suggest me should be standard & my selection range will be
same but the numbers will be changing.

please find a solution for this. i will be great full to you at the same
time.

 

[Joel]

You need tto do the work we wil help! It is easy to write the macro you but
it is better that you organinze the data the way YOU NEED IT.

You have few choices how to organize the data.

1) Have each chart and data on a different worksheet. Ranges of the data
will be in the same location on each worksheet
2) Have charts on chart sheets and have each set of data on ist own
worksheet. Again data will be in the same range on each worksheet
3) Have charts on chart sheets and all the data on one worksheet. Each
chart data will be in its own set of rows (or columns).

If you are puttting all the data on one worksheet, then do all the data have
tthe same x-axis?


Because there arre many differrent type of chart with diffferrent formating
options the best thing to do is for you to make the selection.

I would recommend that you record a macro when you make one chart then post
the macro at this website listing the instructtions on how you wantt each
chart to be made (the diferences from the original posted macro).


To record a learn macro from worksheet menu
1)Tools - Macro - Record Macro
2) make one chart by highlighting the cells and the go to Insert - Chart and
make one chart
3) Tool -Macro - Stop Recording