Charts need to run by macros.

[Sekars]

Hello Friends

Please refer the attached 2010 version file (charts need by macros.xlsx).

If we are inputting any date in `test chart' cell F2 (From 07/01/2005 to 11/30/2005) that month chart will be displayed in `Chart1'.

Now I need to take the values from `Inputs' cells B2 to B6 one by one and need to be pasted in `test chart' cell F2.

So that tottaly 5 different charts will be displayed one by one in `Chart1' and I will copy the charts one by one by using print screen and I will paste it in `output charts' as a image.

Unfortunately I have huge data I cannot make it manually, Is there any way to do this by using macros.

thanks in advance

[Greg M]

Hi there,

See if the attached workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

You can experiment with the highlighted values to suit the layout you need.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Sekars]

Hello Greg M

Thanks for your Code and formula.

After running the macros it is producing the 5 identical charts (i.e., 5 charts with same month instead of different months).

[Greg M]

Hi again,

I'm not at my computer now so I can't test the workbook, but I remember checking to see that the x-values (dates) were different on each of the five charts. Are you sure that you have Automatic Calculation enabled?

Regards,

Greg M

[Greg M]

Hi again,

The attached workbook shows the charts created for four of the five months involved - including the fifth chart makes the workbook too large to post here.

Regards,

Greg M

[Sekars]

I am stunned,

Hello Greg M

thank you

this is exactly my requirement.

thanks again

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

You're welcome - I'm glad I was able to help.

Best regards,

Greg M