Include line chart in 3 d bar chart

[Anton]

I have a 3D bar chart with 3 bars and would like to have a line chart to show
the tren of one of the bars ie revenue , but cannot find a way to do it .

can anyone help please

Anton

 

[Andy Pope]

Hi,

You can not mix chart types when you use the 3D styles.

Convert the chart to 2d in order to add trend line.

Cheers
Andy

 

[Anton]

Ok now i am working with a 2 D but the trend lin is not that good i mean its
not exactly on top of the bar i chose is there some way how i cna edit or
format it ?

Anton

 

[Andy Pope]

Do you want an actual trend line, which will in some way be based on
your data. Or do you just want a line at the top of each column? In
which case you can use a new series plotted as Line chart and based on
the maximum value for each category.

Cheers
Andy

 

[Anton]

sort of what i need but still do not get the exact pic , i have a specific
column that i want a straight line going from a col to another .....

Anton

 

[Andy Pope]

Then you need to create the line using a series.

If the chart is a bar, horizontal bars, then you will need to use a
xy-scatter rather than a Line.

If the chart is a column, vertical bars, then you should be fine
assuming the line should go between the center of columns.
If the chart is a clustered column chart then you will need to use
xy-scatter in order to go between the centers of the required columns.

Cheers
Andy