Poser of the day. I spent a half hour trying to insert an array into the
chart series' XValues property, and it wouldn't go.

If you construct a chart using a range to produce this category axis
pattern, then use the F9 key to change the XValues, your category axis
labels are put into this array:

={"2004","France","0","Italy","2005","France","0", "Italy"}

which is just one dimensional, and shouldn't work. And it doesn't if you
enter just that into the XValues.

Building 2-D arrays and saying .XValues = MyArray didn't work for any
array I could come up with.

All kinds of text representations of two-dimensional arrays which should
produce the proper array in the worksheet don't work in the chart. Here
are a few examples:

={"France","2004";"Italy","";"France","2005";"Ital y",""}
={"2004","","2005","";"France","Italy","France","I taly"}

Even the usual trick of making the chart with a range and using

.XValues = .XValues

fell down.

Probably someone will come along in five minutes with a simple solution,
but I'll go out on a limb here and say, you're out of luck.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

syrhus wrote:

I'm trying to manage data's graph from an array but when I try following case

|
|
|
|__________________________
|France | Italy | France | Italie |
| 2003 | 2004 |


I don't succeeded to generate the appropriate array.
Does anyone know how to do that WITHOUT ranges?

Thx