3D chart

**Bazman2** · 08-18-2009, 08:40 AM

Hi There,

I am trying to produce a 3D chart along the x axis there shoild be 14 points along the y axis should be dates (2500) and on the z axis a range of values from approx 0 to 10.

Now putting aside the size problem for one sec how can I control which axis is which ix excel? I tried transposing the dataand imputting it but no matter what I do i ned havig to go in and define the series by hand which when you have 2500 of them is a rather daunting task!

2ndly given that I have 35000 points can excel handle data of this size. If not is there anu add-ins/ work arounds I can use?

Baz

**DonkeyOte** · 08-18-2009, 08:45 AM

Baz, I will move this to the charting forum in which the experts are more likely to see your post.

**Andy Pope** · 08-18-2009, 08:54 AM

The number of points will cause a problem for a single series.

What sort of 3d chart are you trying to create?

**Bazman2** · 08-18-2009, 09:13 AM

Hi there,

Find attached on sheet 2 an example of the graph I am trying to create the y axis that currently has s1-s13 should instead show the dates.

Even to get this far I had to go in and set up all the series manually. Despite transposing the original data.

The original data is shown in sheet 1.

Baz

**Andy Pope** · 08-18-2009, 09:53 AM

I just selected the range on sheet2 and then plotted either by rows or columns to get the 2 different layouts.

**Bazman2** · 08-18-2009, 10:09 AM

Hi this was the problem I was getting.

Even though you plot one by rows and the other by columns. x and y axis are the same in both plots.

The dates are the x axis in both plots. These should be the y-axis i.e the one numbered 2-15 in your plot by columns an just 2 in your plat by rows.

The y-axis in turn should have the maturities 2-30.

The z-axis shows the output for each point in both graphs which is correct.

Do you know how to switch the x and y ases? I did it by hand to create my example graph, but this is simply not feasible for 2500 dates!

**Andy Pope** · 08-18-2009, 10:14 AM

No, the 2 charts I posted have different x and y axis.

Select the dates on the ByRows chart and the Categoryaxis name is displayed in the NameBox.

Do the same for the ByColumns version and Series Axis is displayed.

Both of these axes are actual categorical axis. Only the z axis is a true value axis.

**Bazman2** · 08-18-2009, 10:52 AM

Hi Andy,

The only way I can to the correct graph is to highlight the whole range C4:HS18.

Select surface etc.

Then manually change each series1 from C5:HS5 to C5:C18. And repeat for each of the remaining series .

I then define the x asis to be the range D23:Q23.

This gives approximately the correct format. (I would still like to label the axis which currently shows s1-s13, the dates shown in C4:HS4.)

The main problem is that I need to be able to plot this for 2500 dates.

so a.) I want to be able to code the above prodecure into VBA. To prevent my getting old and grey before its plotted.

b.) It is possible to plot this amount of data in VBA? I hear this is a limit of 4000 points, where as I need 35000!! Is there a get around for this?

Thanks

Baz

**Andy Pope** · 08-18-2009, 11:10 AM

Sorry I can not see what you are trying to do.

There are limits to a chart.

I think the first one you will encounter is a maximum of 255 series. This means that you can only have the dates as the category labels.

But as I said, the x and y axes are both categories so with 255 series on 1 axis and 2500 on the other you will also get a super skinny chart.