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 wrote:
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" wrote:


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 wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info