If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column Chart With Averages Displayed
I'm trying to create a "100% Stacked Column" chart with the Averages for each
series added in as a secondary axis. So I'm basically trying to create a combination chart, with primary axis being the 100% Stacked Column chart and the secondary axis being a scatter plot of the average. Anyone have any ideas? Thanks. -- Regards, Dave |
#2
|
|||
|
|||
Column Chart With Averages Displayed
I'd probably just be content with a line series for the average, and not
deal with the different X axis types. Calculate the averages in the worksheet, and add this range to the chart as a new series. Excel will very helpfully add it as another brick in the wall, so select the new series, and using Chart Type on the Chart menu, change it to a line type. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "David Billigmeier" wrote in message ... I'm trying to create a "100% Stacked Column" chart with the Averages for each series added in as a secondary axis. So I'm basically trying to create a combination chart, with primary axis being the 100% Stacked Column chart and the secondary axis being a scatter plot of the average. Anyone have any ideas? Thanks. -- Regards, Dave |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Positioning Numeric Values Resulting from 6 Column Array Formula | Sam via OfficeKB.com | Worksheet Functions | 2 | January 5th, 2006 02:03 AM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Column and Line Chart | Nikki | Charts and Charting | 1 | November 23rd, 2004 06:21 PM |
Clustered Column Chart with Second Axis | Jon Peltier | Charts and Charting | 0 | April 10th, 2004 04:56 AM |