Dynamic Sparklines

Hi Salvucio,

I will be happy to help you but I suggest you to attach a document so that research can be done

Here is one way of doing this:

Select a range of cells that will hold the result of the following formula which is an array formula for the whole range. For example select C2:C32 (for 30 days) and enter this formula

Formula:

Please Login or Register  to view this content.

Make sure to enter with Ctrl + Shift + Enter.

This will produce a listing of 30 values. This range of 30 cells with the values is what you will enter in the Sparklines Data Range.

This will produce the Sparklines chart for the 30 days.

Explanation of formula

$A$2 is where the dates are starting in column A.

MATCH(TODAY()-30 is the rows offset from today's date in column A it is looking for a date equal to today - 30.

$A$2:$A$300 is the range of cells where the dates are.

1 is the offset of 1 column making the column to return values from column B

30 is the height of the array in rows from which to return values.

1 is the width of the array from which to return values.

Your attachment to message #4 doesn't work. Can you upload a workbook instead of a picture.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I have given you two choices for the Spark Lines. The choice that I have in the After worksheet takes data from Sheet2 and covers 30 dates of data (not 30 calendar days but 30 data entry dates) The second choice is 30 days...Take your choice.

The RED shaded area on Sheet2 is important to be left alone. The formulae there are very sensitive to changes.

Glad it works for you. Thanks for the feedback.