#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Combination charts

Question, I want to make a stacked-column chart with horizontal lines and I
can't seem to do it no matter what I do like even change the series. PLease
help!

--
thank you!
Mavy
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Combination charts

Hi,

Is the stacked column the 3d variety? If so you can not create
combination charts with the 3d types.

Cheers
Andy

osof wrote:
Question, I want to make a stacked-column chart with horizontal lines and I
can't seem to do it no matter what I do like even change the series. PLease
help!

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Combination charts

It's not the 3D type. It's just a stacked column with negative figures as
well and 3 horizontal lines.
--
thank you!
Mavy


"Andy Pope" wrote:

Hi,

Is the stacked column the 3d variety? If so you can not create
combination charts with the 3d types.

Cheers
Andy

osof wrote:
Question, I want to make a stacked-column chart with horizontal lines and I
can't seem to do it no matter what I do like even change the series. PLease
help!


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Combination charts

I just created a stacked column chart with 4 series of data, including
negative values. Selected one of the series and right clicked form the
context menu I picked Chart Type. Selected line chart.

What have you tried?

Cheers
Andy

osof wrote:
It's not the 3D type. It's just a stacked column with negative figures as
well and 3 horizontal lines.

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Combination charts

I've tried that as well but to no avail. it changed everything to lines..the
value of my line series are percentage. no matter what I do it won't work.. I
have to manually add a trendline to form a line.. Help! someone said it's
possible but they can't remember how they did it...

--
thank you!
Mavy


"Andy Pope" wrote:

I just created a stacked column chart with 4 series of data, including
negative values. Selected one of the series and right clicked form the
context menu I picked Chart Type. Selected line chart.

What have you tried?

Cheers
Andy

osof wrote:
It's not the 3D type. It's just a stacked column with negative figures as
well and 3 horizontal lines.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combination charts: two variables in one series? Bob with Q Charts and Charting in Excel 1 September 14th 06 09:55 AM
Bar and line combination charts 120044 Excel Discussion (Misc queries) 2 July 25th 06 02:31 PM
Column-Line combination charts [email protected] Charts and Charting in Excel 3 June 8th 06 03:04 AM
How lines in combination charts treat #N/A values Bernard Harris Charts and Charting in Excel 1 February 16th 06 04:15 AM
combination charts - multiple columns Colin Whiston Charts and Charting in Excel 1 January 25th 06 11:54 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"