Include line chart in 3 d bar chart

  • Thread starter Thread starter Anton
  • Start date Start date
A

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top