Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple data in stack column chart
I need to create a chart with 3types of data. 2 of which need to appear in a stack column format the other needs to appear in horizontal line format. I am able to do this using normal columns but my client is wanting the stack column format. Is there a way to do this? -- SMueller ------------------------------------------------------------------------ SMueller's Profile: http://www.excelforum.com/member.php...o&userid=35957 View this thread: http://www.excelforum.com/showthread...hreadid=557477 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple data in stack column chart
Make your chart as a conventional column chart. (two series)
Copy the data for the third series, select the chart and use paste special to add the data to the chart. Select the third series and change the chart type to xy scatter. Select one of the column series and change the chart type to stacked column. Worked for me. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "SMueller" wrote in message I need to create a chart with 3types of data. 2 of which need to appear in a stack column format the other needs to appear in horizontal line format. I am able to do this using normal columns but my client is wanting the stack column format. Is there a way to do this? -- SMueller |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Column charts with multiple data in each column | Charts and Charting in Excel | |||
merge data from multiple columns to single column | Excel Worksheet Functions |