Include line chart in 3 d bar chart
 

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

Include line chart in 3 d bar chart
 

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

Include line chart in 3 d bar chart
 

thank you

"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

Include line chart in 3 d bar chart
 

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

Include line chart in 3 d bar chart
 

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

Include line chart in 3 d bar chart
 

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

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

Include line chart in 3 d bar chart
 

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

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


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


--

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