• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

nm, I suck at Excel. Thanks for the help Rogue

R

RaynorWolfcastle

Diamond Member
I've been looking through google and the help files to find an answer as to whether it is possible to superimpose two types of graphs. What I need Is to have a line graph superimposed on a histogram (the line graph is the running total of the histogram data series).

Any idea if this is possible?

Mods: I know this belongs in the software forum but it doesn't get as much traffic as OT, lock it if you feel it's necessary.

here's the type of thing I want
 
Okay, so you want a column chart with one series of data and a line chart with another series of data but in one chart? Let me see what I can do.
 
I don't know how you could do that in Excel, but I'm pretty sure the program "Graphical Analysis" can do that.
 
I'm running Excel 2002/XP and I was able to do it by selecting my data and clicking on Insert>Chart>Custom Types tab>Line-Column on 2 Axes selection in the Chart Type selector window. Do you have that?

Extract from Help search for "Combination Chart"

About combination charts
Combination charts A combination chart uses two or more chart types to emphasize that the chart contains different kinds of information. The chart in the example shows one data series (Projected) as a column chart type and the other (Actual) as a line. To create this kind of overlay effect, select a custom chart type in Step 1 of the Chart Wizard when you create a chart. This example uses the Line ? Column chart type. You can change an existing chart to a combination chart by selecting the data series you want to change and then changing the chart type for that series.

Secondary axis When the range of values for different data series varies widely, or when you have mixed types of data, you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series. The chart in the example shows the number of homes sold on the left y-axis and the average price on the right y-axis.
 
Originally posted by: Rogue
I'm running Excel 2002/XP and I was able to do it by selecting my data and clicking on Insert>Chart>Custom Types tab>Line-Column on 2 Axes selection in the Chart Type selector window. Do you have that?
Click to expand...

ah crap how did I miss something so obvious, I feel like an idiot. 😱 Thanks for the help.


Not that excel was much help at all in helping me figure it out. I typed about 10 different combinations of overlay plot, combine graphs, etc. to no avail
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top