Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Microsoft Excel Chart object in VB6 | Charts and Charting in Excel | |||
I have had difficulty in creating user defined functions in Excel | Excel Worksheet Functions | |||
Can I create an Excel chart with two x-axes? | Charts and Charting in Excel | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel |