Calculate Next Date for Data and Chart Results

[kielyscott]

Could you possibly please see notes on this spreadsheet and attempt a fix for what I need?

Thanks

There are only one or two...

[smuzoen]

Firstly could you edit your post so the Title for your post is descriptive of your requirements - e.g. Calculate Next Date to Add to Worksheet and Chart Results - please edit your title - this is part of the forum rules
You can easily add a date and format the cells with the Add New Week button

Please Login or Register  to view this content.

You must format Row 8 as Custom dd.mm.yy - see attached workbook. You also want a chart - you will need to be a little more specific - what sort of chart, what variables do you want charted as there are different units for the Quantifiable Measures - if you could upload a sample chart showing what you want that would help significantly.

[kielyscott]

This is excellent! Thankyou!

Also - see second tab 'Graphs' in the workbook.

Thanks.

[smuzoen]

Sorry - did not look past my nose. Late here in Oz so will upload the chart code tomorrow morning for you unless someone else picks it up for you. If not will post solution tomorrow.

[kielyscott]

Excellent!

Thanks for your help buddy!

[smuzoen]

I have added the code to the button to generate the graphs - as the data table expands the graphs will incorporate the new data - test it out and if any problems let me know. See attached workbook.

[kielyscott]

Hi Buddy,

This is great but there is no date on the bottom of the graphs, if you couild implement this it would be great.

[smuzoen]

Sorry - was using relative references instead of absolute references - see attached workbook

[kielyscott]

Copy of 5 Quantifiable Measures (Macros) Update 8 5 12.xlsm

Please find attached spreadsheet as mentioned in PM.

[smuzoen]

Will have a look - sent you a PM - will see if what you want done is possible.
Be in contact