dynamic chart with 2 label X-axis

[juzzi]

hello everybody, my problem is the following: i would create a dynamic chart that shows the last (let's say) 21 values and i manage to do this throught the definition of names, but i would like to represent also a double label for the x-axis, that is year (column A) and trimester (column B)..how could I do?
the name I created is the following:
=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;1)

 

[Andrew Poulsom]

Welcome to MrExcel.

Try changing the last 1 in your formula to 2.

 

[juzzi]

do you mean into the formula for the name "trim2"?

=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;1)
THAT WAY DOESN'T WORK...
THANKS

Welcome to MrExcel.

Try changing the last 1 in your formula to 2.

 

[Andrew Poulsom]

What's in K1?

 

[juzzi]

is the number of trimesters I want to show...the last 21 trimesters

What's in K1?

 

[Andrew Poulsom]

If K1 contains 21, the formula:

=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;2)

works for me in Excel 2003. It refers to the last 21 values in columns A and B, and assigning:

='Valori assoluti'!trim2

to the Category (x) axis labels results in year and trimester showing.

 

[juzzi]

i did excactly what you wrote but an error message appears:
"the reference is not valid. references to the titles, values, or the dimensions must correspond to a single cell, row or column"
do u have any idea?
otherwise would you please send me your file so I can check what's different?
thank you very much bytheway


QUOTE=Andrew Poulsom;2837665]If K1 contains 21, the formula:

=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;2)

works for me in Excel 2003. It refers to the last 21 values in columns A and B, and assigning:

='Valori assoluti'!trim2

to the Category (x) axis labels results in year and trimester showing.[/QUOTE]

 

[Andrew Poulsom]

What type of chart are you using? The named range has to be assigned to the Category (x) axis.

 

[pgc01]

Hi

I tried a simple example, following Andrew's intructions, and got a chart that seems to be like the one you want.

This is what I did:

1- I created the name YearTri in Sheet1
Name: Sheet1!YearTri
Refers to: =OFFSET(Sheet1!$A$2:$B$2,0,0,4,2)

2- I created a column chart with the values in C2:C5

3- In the source data of the chart, in the Category (X) axis labels, I wrote
=Sheet1!YearTri

... and got the chart.


This is the data I used:

<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Year</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Tri</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Value</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2011</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">23</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2010</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">31</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2010</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">38</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2010</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">53</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=5 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>


... and the chart I got:


<IMG SRC = "data:image/gif;base64,R0lGODlhugJsAff/AAAAAAAAOgA6OjoAADoAOjo6AAAAZjoAZjo6ZjpmZmYAAGYAOmY6AGYAZgA6kDo6kABmtmY6kDqQ22a2/5A6AJA6OpA6ZrZmALaQOtuQOv+2ZoCAgJmZ/7bbkJDb/7b//9u2tv/bkP//tsDAwNv/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAAC6AmwBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEkypImTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qNGjSJMOFai0qdOnUKNKnUq1qtWrWLNqTcqUZogDH1J+DStigYetaNOqXcu2rdu3cOM67doUwIi7ePPq3cu3r9+/gAMLHky4sOHDiBMrXsy4sePHkCNLnky5smXAG+TipKvU7uXPoEOLHk26tOnTqFOrXp03s2abnLmynk27tu3buHPr3r3a9WuasZF65k28uPHjyJMrXx7Y92+ZwY8OZ069uvXr2G0D4MC9u/fv4MOLxB9PnsN00c6fw4wus6wH9ybGvjyfvb79+/jzD95evr///9/RB1p66rnEXlEC6qfgggw2WBx/AEYoIXgJXkZggSwdSFSFDnbo4YcgWgbhhCRGyGFlF2KokoZLhejiizDGaNiIJdZY3omUpagiSiwKhaOMQAYpZH402mgkhabpuKMJPapUggUdgBWflPAZOOSVWGZZX5FHdmlekksaCMBTP2pp5plopsall0aWGZmSOzYJlJtp1pnlmmzWSGd1eOZJ4p6Owan/opw/AWrnoTL26aeEhi6n6KIANrqYoBgS6pOkiGb64aOQ+ocpcpx2eiOYYWY45lyapnpmqKKO9+lxrLYa3quHKXnqW7eumGtN7slXZUu0qqparLIi6SCxxXYXLHHIJvtlabamVOSuYhHgQQgDDBTAtVKOha22Z4mggEATiCUlj8BSK52w1jXr7LK8uVssvLvJKyu9gkULl7pM8osgu3w6+2eH9raKb24Fi3owZqWaSibA1CWsMMECM0pxxZGS2rC0/m5omsSQLnwbyCFfjLGnJp88KrQb61qTBg6QYEIJFEwAn3xWlkaynyJrp/J/Pde2c55B0zY0m0XvRWmBlvaUrbReR3v59GpRS53yz+JNPSzWK5O2tHpN86T1XVUfOTZqZZt9NdcBrs22shq33O/DOr+dtdt2P9tg2jaefRrfesbdctg7nQ14iX5/nPeseL+deN2Le3f2188RrpPhkUveuOObc/04aYcPzLLcJxEun69mzad45tx9Plroou/NeuudYz056aV33CLkrLsuGuwT+h4a8CbW/vPtuFueE+azCw8a8cUfO7veDEIPtOAb/yu/2eq9G3+89yc7/5n1KI9OuvY3Md+99NOLfxn5/bkvYvvYN4z+zecCy33m8lcGf/zgw1j/KPM/8iDvfLrzEe72tUAGNrAtCXxgVSLINAoWSoJssSAGo6LBDc7Fg2np4GvQBxsV4ew3ItRKBgwQlkqp6Fcj/I24ClKuyi2QhDVJIQils0O06LCHGwJiVn64LyKmT4hYMSISL7jECTbRiclTYg7hkoGYoe4sJznhlFq4FikmpYokuCJKTkel1GXwLWAUYxa7VUYsdhGNVmzjGNlIFjO+MYpkeiJVvKjHzfRRKnz8I3BuGEhBGvKQiEykIq2Cw0U68pGQjKQkZ9LISTha8pKYzOQSK6nJTnryk6CsYChHScpSmnJQGpQPzWyWOi2uZIAQi6UsZzkayqGwkOuhpS53ycv82P9yhLhUXS+HScxiGueXmuFkTGBpzGY6U5fIlIsyc/nMalozYM2rX6ksVYIKuHGLJoDhK69JznIap4Cu0maYpilMc7rznUajn/nkxs6cwfOe+OQd/9S5pHrqL58ADej8sjnPwQXTngJNqEIXg867FTR7B/3nQidK0f3I02uEpMkMCcLKs7hyRRUNqUj50lDGPdR+Ec3QSFdqUYLKzqW1zCiqWEpTv5TUWC9dH0bxONOa+jQvN20b+3QaU57W5adIJdtFq7dU9MynJBpJV07cgz8uqjSpiAmqUHO6z6F2dafA4phBUPKrj/IkAwBIQP6YJNWeYrUwWtWcVyPHzMjElXYWJ0WXA1+Z0nG+dUbTo96C7ipYBRH2gP/07CtI/wrXwNYVMocNYMUQa1C6MbalMB1sUw272QHJ9Kj6pKtkJzvad5U2WZSF6E0ysK011vGbfgVdZ4nk2NPOy7b34mecFCut/Yl2rr/lanCZmtnQRDMu/ryqbIurH8IWtrmzxU9k87pO3vLIt4t77GOcq13HTFe42dUtKi37uujeh7u4NVh6J0bdfnYQrWp9LTgR+jvz2ge9wM1bdxvz3aIikLz1ZS5t7bslAmenv041amewq9/1she8Dc6v3VKLUgAPz8DYwS+EJ+zgkrV3txZ+Hoavo2HiElWzArbQZxcc2vBKmMMvZtt+GYNg464YJ2oM6ymhs2NK9niZP14oz42FE+T5FNnIR85QkpWsYK4UCARhXGsydySuGqJQRWAEm3qeFCWrxv+wyURe8orE/EoyS8vMev3vB9HMVja3Gc3WRWScATnnOd/kWwCoIc0AwEJzWdWsWrGzTfCsZwrw+c/n2nOfIcgWQp9E0YhuIaTdImivZCvPjzb0ol2b6UNTesg8XEsIrKWSC0DABKb2s6rPKGpSpyTVqZ5jC2F9akarZdSwpfWqdW3rtOC61KeONadRHexas1rNbk62spftyeQy+9nQjjaIpU3talsbhM6+tra3ze25VLrb4A63uIHz7XGb+9zmzja6183ucTftAlYkNa/bTe96d9tSGgCABEyggW3lmEcE2YDAB07wghv84AhPuMIXzvCGO/zhEI+4xCdO8Ypb/OI7GM+4xjfO8Y57/OMgDznDQf2SPWM6nOPatEQvy/KW6+a4RQyxy2dO89PAHFd1rrnOd/7h8bqV50AP+pvVSP4voRv96JMiuseQzvSm50vpu3O61KeOl5tTOudUzzqIauxZMK9L62CPsefEW6kOasDYJ5n3ysPOdumOGDJWh2AqSS2CBnzg37mDqt73zve++/3vgA+84Ac/kPb1Pe4ZfK9AFj1DlSu37ZAvcIotg/guYj3ymCfx2x9TebWo+7qZD33ENh8oqPtI9KhXDtc/0/kQXj71sI8X6RvTeh++Pva4H9nsGVP7rXy+dLkPvu4njyLTB2XGwof86lXsdaMgP/lsXz7ljb+SCyxa7Y+HvvZbHGGw/yaWVxGIcljw3i/Cm//86E+/+tfPfvYbnu+9D3QKcdZ4L8d2+/gP8Ilt3Pyi5///47N7Sdd/SweAdiJ99yWAihF/Q3R7BrgqCggqEYgYDJhEDviAWoKAkrd/XYdsLIaBaKKBBzaBtUJ9hQKCaSKCGUaChlGBV/F7TIKCIciCzEKDhOGCjHSBMigkKqh5xJcjSIYrbUUT+QYArTUzmmZ/i2V07ScQHbYoz5cYPQh3QSgTJgcAaOcSgKaFa8UvYYMtrUV+vXV0JYZiHDhgZ8h8OlY6FJISG2Vsq2QCaTQA5TIWcQhG8AEzMjNspTOEMqEBfRYCDyAz2Hd/QVeGnPWDI1aoiJKhL2wYIChBMzFzEmAUh95CR5YIFr8GiFykRV6ogzqHiNDFiD6YhtNnIMjlh7JBhrUldrbzhDxDdqL0c0Animj4VSaGiwnmgavIhK24YZzjit/Tc/9lJ3Oh+Iu5OFxmqIv8x4vCgXS26Hak2C42OBg4OEGgOFCmmIDVqBtTiE3bCIQEGHXlNY3gGI6LiI4raI6lN44r4WhI6GntVI7qWIr1SI3syBzf2I7OOBNpJEf0dWH56CjIuIzKmIj3yHkmGB+uhhKFuIT0yIyjOJCq140IY5EM447Hx2AwBozB6JFjJ4wqQ2HblI3+g5HDR5HJsY/6iJJ+cY17ZJIE5JJCU5AIKZG3eJAd+H20KGIqKYE0GU8/CStBqTQL6TQc+ZHJqJM56WIg+YrEOIugtVwJOXpFyRosSZBDWYIaOSdJKWOwGIsiGT5hiTSyCDYyORlZWZFXSTUtbbk1W9mCRzlskzaP+oeT0hiXNaiXsseX1jiX4CSGoEeVeHleNjmRhcmNVUl7/4CJMw85hoTJlHm5mFpJmWxpmQsImJfzlSH5lFDpmSNZllYTlWhpjNqYmBuImUCpmkTpl0/XlSfIfR25lE5Jm7NpkLW5izw5lREpmYb5lmoCnGgjnDA5FTCoPqiZjqx5TsL5N8SpmcvDmZ9pm7d5k76pmMnZiNC5PbKplLiZm9YJnoh5neLYj84nncMImqE5lgIkml1CktXVE3UZkD65nA9ymE3ZfdQJlqRZOUYkmMDXnfypnmTJnqRloAIDn+7VE4+ZZmZWbnoEoU0koZu0nUfEZhRaoRjqZhnqfHXGocnWoUAkoj1EokvxoQUiLo4nTepRZfx2hFf2G5u4oqlYIDTWp4Q1ap4IYkJSxqIYskI4ulfqwYlaJkPht4VCCJuXwqNB+mnPcQE0VKS/gVbyaEMFgqRO3qqjQbShIMqlcGahJeSlXyqmZGaiPoKiY0qmYmamHsSmc4KmDxqiXZqmu9kZbKGHSNhR4ARf58KnTfqCdzqJq1RVcphWcoSljLQWeDqorSQlfhpOjfqniaoWi1ozhPqohHpsdepkbcFaWJRjWoSoUMQWnsppZUVHkApbPtSpRwiqqCpOq0qqrQqQgUmrngemU6Smazqncaqk9varwHpuMBisxFqsPzasxpqsyvpJyLqszvqskdSs0Dqt1CpI0lqt2JqtJeqm2tqt3lqM3xqu4opJ1zqu5nqu0sSt6Lqu7KrKQerarvAarwjyrvJar/ZaOPR6r/q6r8uUr/z6rwCbOwE7sATrejZhcvsWjzRasAzbsGLCK3aUqvPlsBRbsRzzMg6AAeQCTrBqsR5LsPgmqDUDoDG4gyYLMcVJZzZxAftGpA0aoCcbs6mSsu5qmjJ7s1lCs1BxnDjbs3Wis2SSlj47tC4CtN5ms0SbtCBitHUhtEr7tAvCtJ3htFBbtfchtVxBtVa7tdeBtbTCobVcG7bL4bXSAbZie7bHhKvAgbZsax9k66FI27ZySxxvO69xO7d4ixt1uyFmm7d+ixp7e6J3+7eh14Rn6Z+DS7iYt5aZ6atio7jax7iJEbhnmriQ23aSS4FHiWciW6Vrd7mxl7lcqaUswbJuGKl2CbqwJ7pyqaRlUQBG6FG2aoiqm3qsWxiUe3w61CuzC5G1a7vPqaREKoiEWGzU9LurG7yke3rIm7yu2RxqS0nN67z2ibud0Qsd0wu8z5uRy7uR2St6t3uD17tM3wu+yrupz1i+mRe+f+m4haO+63u+ldWT8Kt17Pua3euV9at88qta9Lu/U3e/0Ou+mwnA0de/Ffa/Btx0Asy96Pt1C2y/CFySlhvBx7i9f5G7b1rBFkxzDZzB43u8HSx1H/ySIZy6IwyNExyfd5ZoSSjCKcx0JdwXGlwoIqQBAnCoPQqZMSzDK868oDWRARJARvJFnz18iD88bTNxAXX4qhFLu0eMxBhswu7rmMaLwlHMczPMFzV8KX2bxUm1xUZJwNEJxr44xTR8wkZsxv7Tfu6pNv15SxzMxlLYnOi5nt43v7xJx+9jxwLamf71wOfJx/WZnfZInpPRxU7zxYRMGGKMlUnsc3vcyGrpx5Epnqynxp9LyXZlyb2JyWooyP7HyZWMxkJZveJLxtxJyqWMyvUSyeA6yazsXZ58l4isnaqcPrPcyoaMj66Mv6JcgLu8XbUskL88wP/5G5vDTMymPBuP3BqanH3LzFDFXMi3PHSoKKQXq8DT3FjNDMnfDM3ZnKR8NcfdDDXVHIDhXHVV2Gsu4xWk5rJXvMY1F42/ecy48czsPM4yEWs0k4U/oaJW9Yk58Y9FvMk7Z8/Yec2+3MsKyc/TEokUANAo52khgAAMYABdVtGLVoRHCGWeqIpEyELk14QmfdIO4VgonRHvt9IW0dJ654hM0oYrMUOndkW/domv5aLv2IUiPRNUhbr07MH4OZkMfY5HzY9M9oiSgxJEmmkTEKp0BGhPPbFv9s40QaWMl3J/GoWxpNCpmdQtuc53IdMIUWoDMYkVHYavOi5H6NHfFNJ1DsPNMwfWyinWlenQSl1m2gxw5oxUdr2O+JySes2Y/OzO2yzLCV3U91zYeY3XA5guK/3Tg3zGZD2cl+2cl63IYsPIPxXYhwzKjQ3ZjZvMl6LC6dzHmX3HBZrH/qvYF7zafzyd31mdO6nHHyh0oN3QpL2ajh3Z/8FMjlIs25esn7Xtnc0Y3Mxr2YPtM8T9ycad3Ljdi7rN2Ast2tcd3bf92rk93M1dk89ty9hdnsrtvaDjxgiaoG/cJuvdN4crx3TNy73dmuFtzL+9krAsld1t3/PNnKl9mv19n5sdzVCszt99ygfuzP99kgOey7DB2u2Z3qYl4bdF4bkVx8DEKwpQLv12Fi9bssVt2/mp3SOO3OM53omsmVVGssgZ4HtZ39aM4oJ935MLmEDKsU9cfoAH0y49ESrd4xXB40AOEUJOEpyNrzZx4yeRqQit2gkOzjBu4DRO31M+uuXtkFFafzDM3zIe2l3O21+O1GG+19xN3eJN4kbt4id9+eRu2eCmjZSznZ77OaBzTtvhiean+OaPG+d4XOd2fuJ4nt0iHsr/052+IW7iJY7oaR7oYT3mhq3n78vnre3ncn7cdG7pgKybhQ7B0D3oo63mrxzlTl7lrQvpBXzol37njH7Xjv7YrQ7cm17Zna7on/7q+C3qAG7rNe7gOQThB0qgEQ7s6m3h6oXhyeTZWbXgM6ns8q3rVA7qwBzro3zmni7o1d7oqz7j0I7MV67Ms57qgJ7tXn7trC7uVMjrayvpwU7pfY7pf57omS7dZW7o3x7v4U7u2u7s/s3m+2zqZYzq9g7vAb/o+D7utF586C696v7r7D7p7l7pqn7w5C3twkztEl/u5i7mGW+V/F7WcynQaTfPTZ7rGz/WuM7gHY/ZKX/kl9NBKyDtxKrKwxYP7gL/7gR/8fle8rzXmDDPV4FX5EPeED8e9BEB9ESvEEYfEiz/vzzzp8NN2uL6LuAnv+wpr9krz/MtpOVYPOrbns/Wje0FD+Y6D+vzzukzP/C1Pva3XvW+PuyuncCwTfJhr/Fq79tdT9h3T8X+vsr1bvNpP/ccT+ovLvipvPe6vPBu3/Dr/vDtHvE0T+hlL+tn7/fWjvMG//h/j/kIb/gPjvgTLuyJz/gO7/hov/ndftqej1rt7d7E/mCKH/ryDvf7HeN1/+x5D95sn/oV/vYUHN+Soc/Byey/L/yd7OanD+cAT/lgD/gmT/ihfvUJj726f+Gg//mvb/2iv/ix3/txj/LO741fj/GWL/bMv/PRT77TX+zVr/qt3ylefRjAPwJLvxnIbA7/xA9Z4Z/z5X+Z38/tAGFC4ECCBQ0eRJhQ4UKGAAAwhBjRBIARFS1exJhR48aMADh8BBlS5EiSJU2e5ECR40qWLV2+hOkR5UyaNUeqhJlT506dMm3+BHqT51CiRS36DJr0J06jOTdIhBpVKv9Uh1OtTmy6E6lSriiZZgUb9mhXsjO/ikVrdGtZth/PpoWrte1ckG/jWnx6Ve9eiVX59r3LcS3drnYDH944mDBXw4gdj13MtvFjx4ojA50MN+9fzp0F+tV7AYIJ0Qszp7V82eZpyndTq67JujXc17C9zsZdsbZtk7LDbvYcXC9oqyEOfDAhYoEHhb7B7uZN0nnurNCjC6Xe2vr1utm1c8eMG7hw8lGJTzWOXDnzgg7dv4cfX/58+vXt38efX/9+/v39/wcwQAEHJLBAAw9EMEEFF2Swv/IeNO8hvdYzIb3mIMQwQw0l1LBDDzvj8EMRR6SKRBNPvBBFDM+bSgQFADD/ALkUVaTxxBBrxPHDG3PkEcIdewQyuB+DtIpFH4lEUsgkl+RsSCafhMhJKKdESEoqq7RSySu3nJFLL9v7MsyBshRzSTK/NPLBM8skck02g3TzTR7jlBNHOqlMs7w761RxTz5R9PNPEgMVVERCzTy0xDAt5DJRE0MYwKEJ0PRSA4cCYK/RRY+jtNCJHI0I1BEzACABTjXlUgMHSDChBAomRfVLCmPdUgMBTqX1zzzJE5VERrfslcQMVvUyWA8hxbTTLTOQ4FdgPf1URzGdxTPMDJJV1stZn93ygkmprdbTXYUz9kNwoSw3wxAIyDTbKTWIscIHWM31ynPRhXZcLaFNCzJdfkH8t9+AkfSX/0Z9PSt44KsSVrjIhoFk+GFFCz0YYIlzjPjiUDW2k+MaMx4UZJA9rpJkg00GFGUb8xVZZRNHdnnMmEeEOeaaPay4yZkN3Znnnju8WeWgN2z55w2NBhrpDIc2mekVi1ZazahXnFrqqnllWdqryd0a664R/hpscaEG0sVJNUi2tNIEcjFethVwu00kzTYBbebUHu1tt/E2k0i67SZttLWTg1tGvgUO8u+0Bc+b8L0Z73tsrZc020IKQSCBUczv7ZjJyjm9PHNOLV8O8SQ/V6/0zUcHvXSCPVdgAtKZWx252U0XNOe/nGYog3hvF8hZzj9m0nfbW8/UQuDlTtL4CpEfSKF56F9v/vfpnz8+9XYhzhrn6mVMrvRfhccVzu8HonB86Ic/mUjn2RYf19vZ7xPJ98NnTn3tscddV7J7vAB8JuUiGIGPf9ErH/eIFMD3DPBFcTsgASFoviAx0D0OLCBBGCVBA1IQSBaUFOEyiEAZcTByFPtf2IajQouxcC+84xgM9ZRCF0pFhhq7ocRy+LAdIqyHNQRiEIU4xKX9kIhHRGISlU3YHCMu0YlPhCILdRdFKlbRildsTxOxuEUudhGFXgRjGMUoxCmO0YxnRCMPtZhGNrbRjbxqUBzlOEc61tGOd8RjHvW4Rz720Y9/bFBAAAA7" ALT="MyPic">

Is this what you want?
Try this example and adapt to your case.

 

[juzzi]

ok I find the error
instead of
=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;2)

i should assign to the x axis rhis
=OFFSET('Valori assoluti'!$A$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;2)
so that the last "2" tells excel the lenght.

thank you as well


QUOTE=Andrew Poulsom;2837665]If K1 contains 21, the formula:

=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;2)

works for me in Excel 2003. It refers to the last 21 values in columns A and B, and assigning:

='Valori assoluti'!trim2

to the Category (x) axis labels results in year and trimester showing.[/QUOTE][/QUOTE]