Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAKING A 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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAKING A GRAPH WITH A MACRO.
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 "GRAPH WITH A MACRO" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with making a graph | Charts and Charting in Excel | |||
Making a Graph | Excel Discussion (Misc queries) | |||
making a complicated bar graph | Charts and Charting in Excel | |||
Making a bar and a line graph together | Excel Worksheet Functions | |||
Making a bar and a line graph together | Charts and Charting in Excel |