3D references in charts

[igbaria]

Hello All,
I'm trying to use 3D references in charts, but the Excel returns ERROR. Can anyone help me to do this

 

[RoryA]

You can't - how would you expect it to plot if you could?

 

[igbaria]

Let me try to explain. I have 54 tables with the number of licensed vehicles in each month. A table for each month including city and type of vehicle. I want to plot a graph with the growth of this number, separated by city and vehicle type, and add a trend line for each. I was able to explain clearly?

 

[RoryA]

Based on that description it sounds like you need one table and a pivot chart ideally, but you can add individual series from different sheets to a chart, you just can't use one 3D reference.

 

[igbaria]

Thx Rory, I'll try to figure out another way to do this.

Igor

 

[pgc01]

Hi Igor

An example of way to do it:
- write a formula or a udf to return an array with the values
- define a named formula using the formula or the udf
- create the chart using the name as a source for the values