Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Magnus
 
Posts: n/a
Default How do i create a user defined chart in Powerpoint or excel?

I'm looking to create a graph chart with 3 series as bar charts,
accumulated/stacked on the first Y axis, and teh fourth series as a line on
the secondary y axis. i have tried to use the custom chart with lines7
colummn on two axes, but thuis does not allow to show bars as accumulated
/stacked.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do i create a user defined chart in Powerpoint or excel?

Hi,

It is simpler to create a stacked column chart using all the data and
then select and change the appropriate data series to be a line chart.
The you can then format the line series to use the secondary axis.

Cheers
Andy

Magnus wrote:
I'm looking to create a graph chart with 3 series as bar charts,
accumulated/stacked on the first Y axis, and teh fourth series as a line on
the secondary y axis. i have tried to use the custom chart with lines7
colummn on two axes, but thuis does not allow to show bars as accumulated
/stacked.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Using Microsoft Excel Chart object in VB6 fizbim Charts and Charting in Excel 0 July 13th 05 05:14 PM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM
Can I create an Excel chart with two x-axes? ellmcg Charts and Charting in Excel 2 May 12th 05 07:28 PM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 02:32 AM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 09:49 PM


All times are GMT +1. The time now is 02:57 AM.

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

About Us

"It's about Microsoft Excel"