Non-contiguous ranges

[David Armstrong]

Could someone please advise how to specify a non-contiguous range for a chart. For example, Cell A1 followed by the range A24:A30. David

 

[pgc01]

Hi David
Welcome to the board

Your post is very poor in terms of information. This makes it difficult to answer as one does not know exactly what you want.

You should post, for ex.:

- if you need a sheet solution or a vba solution
- what's your excel version
- if you are working in a worksheet or a chart sheet, the name of the sheet
- etc.


I did a test in excel 2000 that worked ok, I created a column chart in Sheet1 with 1 series, and used for the Y values definition:

=(Sheet1!$A$1,Sheet1!$A$24:$A$30)

Please test or post back more info.

 

[David Armstrong]

Hi PGC,

Thanks for responding.

I'm working with Excel 2007, with the data in a single worksheet, and want to graph the Gross Income for a buisness against each year from say 2005 until 2010, plus an additional year for the budget in 2011. But the budget column is not contiguous with the yearly data.

The table looks like:

Column A B C D J
Year 2007 2008 2009 2010 then a gap of several columns Budget
Income 9 15 21 10 skip columns 15

Graphing the contiguous columns for 2007 to 2010 is okay, but how do I add the data in column J to the ranges for X and Y.

I'm sorry, I don't know what a "vba solution" is. And another apology, I don't understand the reference to a code and codetags.

Thanks for your help.

Kind regards, David

 

[pgc01]

Hi again

The syntax I posted for the specification of the non-contiguous range should work.

This is another example.

I want to display in the chart the years 2000-2005 and the year 2010.

I used in the series source data for the X values:

=(Sheet1!$A$2:$A$7,Sheet1!$A$12)

and for the Y values

=(Sheet1!$B$2:$B$7,Sheet1!$B$12)

Remark: to select the non-contiguous range I can also select A2:A7 and then control-click on A12

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" >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</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; ">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; ">2000</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; ">13</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; ">2001</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; ">15</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; ">2002</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; ">14</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; ">2003</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; ">16</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; ">2004</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; ">18</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>7</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; ">2005</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; ">13</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>8</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; ">2006</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; ">15</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>9</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; ">2007</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; ">18</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>10</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; ">2008</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; ">20</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>11</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; ">2009</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; ">20</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>12</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; ">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>13</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></tr><tr><td colspan=4 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>


And got:


<IMG SRC = "data:image/gif;base64,R0lGODlhaAI3Aff/AAAAAAA6OjoAADoAOgAAZjoAZjo6ZmYAAGYAOmY6AGYAZmZmOgA6kDo6kABmtjqQ22a2/5A6AJA6OpA6ZrZmANuQOtu2Zv+2ZoCAgJmZ/7bbkLb/tpDb/7b//9vbkP/bkP//tsDAwNv////b2///2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAABoAjcBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKtFiipMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qE2BRpMqXcq0qdOnUKNKnUq1KlGkNUEo6HAhgAAADqyKHUu2rNmzaNOqJYu1KIAQcOPKnUu3rt27ePPq3cu3r9+/gAMLHky4sOHDiBMrXsy4cV0Ma2O2veq4suXLmDNr3sy5s+fPoO9Cjvxy8tC3oVOrXs26tevXsPECyEC7tu3buHOjDjyadEvTQnfHHk68uPHjyFvPzs28eW3hf3v7Xgk8KPTk2LNr386d+3Ln4G9f/+8rfXrK6jArPPjQQAQJCRyod59Pv779+5e/h98/nm958yeh91N/+BVo4IEI0qfffuARqNd/AJYkoE8OJmjhhRhm6NmCDDZXIV4QRjhhTx9qaOKJoHHYoW4oKqbiiuINFiKAI/JUYos45tjYizA+p6NhPPaYwY2PRahSjTsR+eOSTP4VZI9KNinXkzBGKdeM5iF5EggHENBBCe/F95uUZIZG5YpWAimkh2U6uSZzacKF5XRa5hTnfWd2eCeTeTK4p2B98temX4GGd+ecvtWJ058KvsliZ4U2uKGjuDEKWKTOWZojpmwKhihpit4UJ6dwTkqpbZoSeiqqpq46ZKurphraF6mPckZrpTL+ZtJBJn1QwJcfDCCmTlx6Gf8gdQAkNaqrtMnK160xQsrsq9Iy6+xe0LJaravX6pWtj57qyhayygI6bbd5fdssrKeiK9u57FLq7l3qUmsrvOEaiVKoxX4JAgIc+PrlkeZaG6+j89pVb8J1LXzwmwzT5fC2seaqb4DJGrWswRS3+/CaEc818b0ck8ztx0IeejHG5QY28mYvaxZzZjNjVnN++Jpccb4rlxDqUQWf3LG8KENZdJVHo5m0nkv7aXHPP9e0sdA6ezw0wk0LejXEWRvataQ8rxw1TVPvXDXRW4P8daZrd3o21mmn/LTYGeNEgUDGEuxyzjDzLbPfNANus+A4l9y34dH1LGHdlO2NeOCPDx7/eeFUH17535NbdvNen0Y29kxlW/0213EbXTrSpyudOtOrOx32xZ/LFDrao6vduta1y32717uDnbvpvCnuM+OnBW225cdjfjnky0vePOXJMx89ecLHLpnxoiOfvfLTQ7+99N87373mhHNePfHBYU+79utzH7737YMfv/jvk5/5g+frdIFAELCEPo1QC6DYBAg7AtJNeAhMoAIXyMAGOnBxkbnbQB5Qgv0BoH8V5F9JLIhBqkhQIBTk4AY1WBKtDMyDBAkhCUX4QQBQEIUTzOAFRzjDEkjwhTAEoQwxKEKTqMcqLVRhDXt4QyCmcIcmMSENO/hA2f2viVCMohSnSMUq/5bmiVbMoha3yMUupsV6XgyjGMdIxjKeB4tmTKMa18jGLIKxjXCMoxznKBZFBdGGOpTPoPbIxz7usXNreaNLQubHQhrykKoBpFoEOSZEOvKRkJyPIr+IRhJF8pKYzCRcNoc/xTHSf5oMpSgLycm8TBItn9TjKFfJSj6Vr5NQqyRKBJZEgNFSb63MpS5NVEoQ5U9juwymMBHUS9H80i3DTKYy51NMu5zyLKnE5TKnmaJXktKavvSkLJNEzW5+ppl7BCddnmmWaJ7Hm30UJ2LUWSZ2xoWcZfmZEk/yQ2niyJ1Swidh9OnK+5nymI3TET8B1ZG2lap3bMOkPuHJlm3qhBKQsBmo455nP4pWRqICxaYx/Rf/T3IBc6Lju6hGF4NRN/lzRyN1UUoTs1Bx+Uw8K1HPBcLSq/aUgD0WoOlJPvAVDM5TQh5FJkjrJ9KTMqakqjIqSVe6TqYepqX+G8lEghpQk1rUMUidlVPVpFSVdpWlWy0MVGOZla3ctD1hUqVVQ4rVsO7TrYPJ6rPgqj64/Q51wdNmyy5F16HOD352ZV9g3ffXirIVpV+dC0PHYs591ZV0d1VdZFk3WddVFneChWxmbZdXsn6Ur4l9al9Be1XElvaoo10rUdsa2ncCtHh+Haz8ZEu/whb1tEttrVhTm1TcFkmvn1WtbVnrW7Dq9q3HjStvtZrcx3IWMIuto0NZMgIR/5SgAkwc3kXOJdWDcLe7BfkueAci3vEuzLzktRZ6BVLeiETXKo0NkHN1d1ne1dd3m6VvfoG3X7z2V7LQfW36YqtZwtIWsAWebYJre2DDrta0h92oZ4VK2gjntrhNbS6Bn2vgBSOYwwoGMfWAS2HhNvi2FvYqhkWr4Qo/GLUtNrGHzUfiqvY2xcZdMVd1vNsY3/jFF8ZxhnkcgvdWJXYzLQkFsrur+fK3wyL+sH6hPOUQV5nBM0YxkH87YTp6+ctgDvNU4hsUEybZhhA485LVzGSpmJmma4azT806ljcrOc1yTiKdrWJnNLO5JBWooVj6HOc7X/cB9Rz0VtjMaK+AhRAshJ7zl/4sRjKL+dKYzvQctC2t6U57+tNc5DSoR03qUitQ1KZOtapXHcjpsvrVsI41jVwt61rb+tZHpjWud83rXgdH174OtrCHLRlXVyAsJIgABNJK7GY7e9ehCtawfIhDx6Lz2thukpGpwmmIZvvb4E7NtscMbLKF+9zoRtC4pdLtdLv73ZIUsHXgTe96H2fdUWm3vfdt77EeMLj8Dji6/Q27coNO4AgfuFvxDRV9J/zh2Ca4vhwO8YpTU+JGorjFNz5MjP+LyNXJFghNe2hPjps8lx6fdVYAVsE8Y2y9MI+5zGdO85rb/ObobS9EGP4UjZ/856NMeZYMLjugG32VQqcT0a939KZnMumJWjpMvO30qtcH6qCSemmsfm25ngjrntP6ILmOTq/zcuHyBgrVyb4ks2sI7K3eK9uX6fYMwX2RYm/k3Om+XBTdnZJy3/tw6k6vvn8d7TWGreCJQ3iFGf7sx+W5U+Rp1q58RafnXDzjH58uztsd8V2OyTyLqNZ7eh5DjW/Y6S/0d1TmHZQ/Sn2CZC+y1Vuo9dB8felbRPsp2V5iv6+9j3kP+n+X2PTDn2vysRV83y8f8kTGku6TRFXFO6kVoAh1238pu33Ldh+zMsP+fRPa2SN1//RI08+8i4cL4S3nWMgsJrJyn995+r8r8i5dEOPuljf2WHfJ0nZWHmBThTZPP+Uz1Tdg63dixAV/O+aAPSZ/TuZfVPZkVmaBI0Ydu2IQ9BRDMhQW/ndWImBBcCYQDGBdJXCAT+RzyieBG3ZlUoaBMUiBF0iDWBZlDsZ+EmZ+44J+gcdcLriAWdaA7jdkEIhcQShjOKhlOuhMaTcgEwhgFWiDMyiFNWiFNwiDOciA7deEXGZ8NgaERzh/SfhjXvh+RRh/YxiF3DeFWOgfT8gSSkRp6qeEWsiEXAhjZSiGafiAfRiBa/iCMkhjoQcT80RydWiGeRhkf4iEgSiES0iEZ/9ohI1IhkcoeU3Bgsxnf4XHiY7niaoHisAnisK3hy14iXFoSYJIhVs4hF24iCr2iHY4iHjoinqIiomngLPIirUYia9oi4w4iWpYiWzofW7Yhn6BiUyhid7SfHHRe8/ojJskjSEAjdNIis4XfaloI8UIfleIjFlIi5IIi2gojH5ojoDYiMq4FMxYf6a4ie/YjNgYjfN4jfHojrKoiMD4hQX3g6dIjKv4hq3oi7cIkJB4h+O4j+VIjoq1jdwUkOBYhRE5kAj5iwQZjAw5jOjoiOrokA/Vjfb1fSF5jMb4jSUZjryYkBcZix2Zi/MGkScpkTFJkeJokRVZkBtpiQa5iwIeCUtgWBO3BHsHWZM4mZHnaJTpmJMgiV8k6Y0o2ZP//+SSMnFm2LV7/6iUMOmUMqmVNJmSNkmUGKmQlLiR66gU7Xh/94iW+ciHWDmUXlmUYqmRSMmRZOmRdrKU5CeSTGmSXNmLNxmWK7mQcXmUgykndrkoeKl9TTmSfMmYTzmRfgmWLNmWPAmZUVmIL+mWUPmVbwmYfzmZc6mTlKmPgTmWc1mWypJ+1qaZlsmZmwmXpSmXhUmXoZmYBzV+ipmMhykqtlkrepmXi7mXjzmTkdmZoDmbonmauwk0WemYW+mcXfmanimZghmbhGmdSamcUgmFzSmcz+md0dmasPmZ1UmepomcvYkrrzNxqilf3QmcjQmexSmdx4mdtIme75mbw//Zl5f5k7pImuYpm/aZnPjJmsSpkgF6nQmanbOJmhpDdP8SML9ilfC4lldZm/l5m7+pn98Jn/sJnfMpnk64nTDhf8x2HgaUcSkqIisKQANEos8WozJKbKg2ozZ6o3RUozhxbGCibBEqMD/6K0F6QlLBo8kGAUM6pCnYJURapMjmo7YkpFHaAUaqbFVRpUg6pUOaZAcYFViapFNaEjxVbU7ao1kqoR0wpCd6pU96prTULykYppXWnj8RgCIYJiYKH3k6bVJhp3u6pyW0Z1Thp2ilp4UaH3ZqFYTqHobKqNOWaFOxqHh6qIHmgYMqLGJ6qIBKbYqKqXcKH4EKLIc6RjoMiqOmeqplVKqouqqs1OpGdNqqsBqrVaSqslqrtoqZt5qrujqnONervvqrwBqswjqsxFqsxrqryJqsXkSrytqsztpwr/qs0jqtPRet1Hqt2Hoa1pqt3NqtdrKt3hqu4npF41qu5jp54Hqu6hquzLqu7iqt7fqu8pqsihJyj4ZHAJA387qv3Do26hGU/Bqw2CpPLFcC1XVd2UUQGLCwDNuwDvuwEBuxEjuxFFuxFnuxGJuxGruxHNuxHvuxIBuyIjuyJFuyJnuyKBuxhxmUVNlmPqN5MHtuDuoW0bp2MXuzUjKzt1dRszjbs96ks9rqjz47tLoEtL8mtESbtKNktNbBs0r7tK3EtGrntFBbtaEktQNCtVa7tZGEtRSitVwbtofktSQCtmJ7tsohfgEGo9yItm6rHMXXjwD3tnRrUL6ZOGz7kHW7t9mnoXiLq9zJt4Ibnx4Kh3n7kYObuOF5oNkEuBSiuJDrmiLKj+yJtJF7uQbKn43rn5mJuZ6bntFSfnJ7fJ9buhfaoMspNaa7umypnY6riqwbu52ojbWHe5eye7ujSLuvixJfKqeJiLu3i3vlBGyRRqHAu7rCG0+0JqmgWnLHy7rJ21AzcUeIuJrPK7vRy1hme72mm73SZbnce7neC1/bG76eO765Br7mq7joy23lu76R277kpr7wK7jyy27vW7+Je7/5lr/6mx0e8XRxW7lz+7/eQY14MsAZ578GjBzWiB/8C63028DF8cAJjH+1i5gUzEwIbB8RXK0TvMGxYcEerMAfF8Ii/BokfHUm/6xyBZzCx7HCjYLBu6u3MIwdMszBNMy5anfD2pHD3fHB6IrC0Ku2wVm4hyTEmcjAuPvAQHzAOzy6YRi+TtzBLBzFBDwTo4c3Tdpk+lvF9QjBLTx0M0ECE7ABZgWwzsu9YJyWqDfGSldWA3OwVflyxnrHeNyrOtdde5zHMdfHDUG2NqJrc0hTdfy7fmfFM+zGn8jItwfHUUfEBvLE29HGFnp4WLzAklwglPzD1NjJAAzJWbfJYhzGF+zIuXvJ0IeLNYy4GRXGlryTAEqdbaLEy8jEjwzLn7zLplzCmXzCL7zKsty6BVqZjDuetNxOYwysCdi5yIfKpajK+DjMpzugbTy3zOd3RqR8ytKsltRcod8sj9B8IEKXrlPXzD2coXdLuBy6uJqLzMZZnsmsoPPMoPYpfTFhQYK2EiH4Eir/iM6Ba8zvPJ3xfJ7WrM7qiZt+y84L/aHy2Z8oKiEwlakoaBIkeFMGkAAEoAHtcdH2SkFmjMZEuoK4nMrhPM2jScwHnbkgiqD1fJ8rLdAtvbkR/VKokhL9os8uFII4lUI8da+heiw+GMwojaEs/dCSe8wETZ/yXNACuqAwDdX4LNE3vUHGcqTShtU2xR4eICxHyqM29EL/PNSkW81QTaAxPctOTc9rbc9nDbraotDrnIE8yFgA/bgIHbob2tAd2s4hqtT1+dZ5Hdd7PdeGq4E9qM1E7c0pbdYvjdaCfdRI/NcDHdiPDdfgIrr7ks37UtLRfNKMbdQyjdTwzNQGHdmj/z3ZLt3WRZa65jbYmV3YCS3ben3Efr3apv3Ulw3b67KemrzYs9vNwQ3aw93Y4Gzc4izcjazcoai7PBzQap3bbC3dbr3bkn3bSV3ZTU3dUf3Sgpwknp2NzG3SyF3UxRzdk7vd6X3a1p3a2L2DUix6dFa97nndfO3OM13a663brA3Z7Y3egK3eAd6QGRzSaTyqa5zcxL3cC97c4/3Z5R3a563SqA3g2k3grbwlledyG7hd6rVegCwSIR4SIw4SJf4RJ+4RKX4Q3/1QhGxWSprg5p3WFP7fNd7fmN3bcj3btn3flJ3fI5rhGmzfho3fpL3U+z3dSV7dOM7b9kLbhP23z0iN10TO4wxd5D9+5Jbd5FVe21du5Q6t2jSdxVN83KJt4UC+5dzt31zu3j6O20ve3azd4t9KyrEc4cV95je+5jn+5D2O5XA+4Ff/4toH5+RUd+d67thtjuZaLuAXzt/cTeeLEt70OM6V/uDi3eDknehmPuGKzueGPjfx/Z97HudsDupdHuVf7uVh/t5ILuhKDuuGmcG8Gep9C+jZneaOruvsveilLutyHumEXnS2vuOs3tdvnuuN3uuo7ua4rt/ALumiQun2iOmXrukQzukKjucMzu0Oju2ZXpe0zpypHtt/DubI/uyv/uixzu5M3uyMLubwTebWF++uruam3ueHzsuWXu3gfu3iLuS1Xu46DuXmvuqq3urJDu3uHuz5XuxrK/Dk7uzobuTyvu68DukPT/B+jvAHr/DqTrm/XdadTuOfvvEUf+wWf++7xb7sGg/spx7n0n4U1F6N/G7t/u7tm+7pJV/hv97wMR/tw850HL/vunz0/W7zSI/zSu/co+7MP5/x7S71747y9r7wGO/yU6/1VS/04666EH/uKp/lF4/vMK/vdlvxZM/yGD7lsJvyCZ/uah/oQI/2tz73yl72La/3bf/06Vz0aT/2dE/1Dn/2Ye/xBS/2cU+Ibu8SayrjEm7yPW/jJ2/4gH/3gp/3bP/yDT/zUkN0lgfUiDz5vl75dX/4II/3DE/4QX/6l6/Z/yOvE5Ba33D/8XKf+avP9YXv+rWf+Ijf8amP+0He+C5BepCf5zy/7do+4z5v+qxv98a++GuP9SIPzCSv/MnP/JRP+vAe9brf+s+P+rcv/RBN76Tu/N8P/Qbv+8FP/ppP/Xu/+VvP94P+9a/9+usP/ONv+ysP/wARQuBAggUNFgSQQeFChg0dPgRwUOJEihITPsSYcWHEih09ItQYEuLHgxhKnESZUuVKli1dvoTJEgCAmDVhciQ58KJInhlw5gRqcGfPkD+DHg0xlGhGo0iBKl060ilSqFEbNp36sarVjVmPbuXq06lJm2XNnn05Ey1arB7Bcm3rleJbq3HlWgyL0f/uXaF5pfJ169fhXsA6BV8tHPhwV6Rk1z6GfJNm5JqE8S5WaLkw3aiaAXNe6pkvaKKi75LuaVouap6qvbIW6VqgY8q1Kau1nZYq5syJO8Iu6rsicI2ypxJnKnwub7HKL2M27hS53rG5rT/GfX2l7Ol/nYPkHX13+O8Huw8u35d8eoLnEbM3vP4obe310062j5I7c/Ff+cOPDzoABXKPof6CKpAxABPsbUAGm5svPwlbyk7C/eSD78EDn/rPwQ4X/DDDENnTsLoJT9QPPwvHE9BDDEkcMb0SXWwRxBdljJEk+lDMr8IeWVxsw5xmtLFGEW8sj8gjjYQRyY925LE+H+15u5BJHJ10TskmrUwyx++0vJLLJ6M8cUopgTxMSJLA7BJL5dj80sss5XyTzoqgJNM6M7WrMsgBk7LTNzjndFO4QessVNBAJ8IzT9v2vK7PNP881NBFN7v0s0xH2/S0Tglq1NHbVPzRv0QTq1TRUzFdVdNWOX3V01hBFf+VSlKpRFMwNbX69LVes0oV1V+PG1a6YUOtFbtbzzRVTEKdRRRaS2f1lVpgi83VL+OQTZatZfnMNq9dFZNW1XKFtZbYdI1dN9ywtu020m/LumAmCFySVFdKsW3WTxr9LRLgJQXekuCcuI23LEhr+qABEUiQgAMK3YVr33b7nfTfjAPeeOCOC/744IRzWzimCxw4iYJ7U5qpZZdfhjlmmWemuWabb8Y5Z5135rlnn38GOmihhya6aKOPRjppmxEeOaaSYQIBAQ4+KKADCpuObF6snd4au67X0vrrq8U2K2yyVTL7bLTTVrttt9+GO26556a766frxjtvvffmu2+/473/+2/BBye8cMMPjztwxBdnvHHHH4fcabbjJSGCmVAuoV4AVtacc3ubrvzykzof/fOTQFDA6pFDBwBz0jP/nHXME5a99M1tX5kC02m3vHXcf0epggdA791101/XHQACVKe8eOBLQF311yPHd/KmhW/44Yizh3hqh7vvGvvvtx+fAxIm2CD1r8XX3vv2UxI+/Ae4J//909Xfmv3u6ZcY4gWGlx//BFg1sukvYudLn9X4R73qxS1qEjtZyiAQwRKojIIqw9oDM4c5C3JwZdHbmgYvOEEPnk5qITzhCEeYEgw2TYQeHGH24pfBFMKwhCMQQQkqsLKRvVCC97PaChkoE+sla4tqzHvgEZNYtSUyr1tHREkTmwjEpkHRhFNjotSOaMUqEvCKStRi1YQYLy5KMYzMm2HCynjGJlJwhyNbIxZVB8IpDnE7RbRjHvW4Rz72UUp49GMgBTlIQvJRcYVEZCIVuci/HZKRj4RkJCU5PzJHTtKSl8RkJrMGSE120pOfzGQlQTlKUpaSkKI0ZSpVuUrHoZKVr4RlLPPmSlnW0pa33BotcblLXvZyQgAICAA7" ALT="MyPic">

 

[David Armstrong]

Many thanks PGC, problem solved. The solution is to use brackers around the X and Y ranges, with a comma between the components of the range).

Much appreciated.

David

 

[pgc01]

David, I'm glad it helped. Cheers!