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

[RaynorWolfcastle]

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

 

[RaynorWolfcastle]

no one?

 

[Rogue]

Can you illustrate a rough image of what you want? I may be able to help.

 

[RaynorWolfcastle]

ok, lemme put something up on the pic server

 

[RaynorWolfcastle]

2superimposed.GIF

cheesy, but you get idea

 

[Anubis]

did you try an overlay plot?

 

[RaynorWolfcastle]

Originally posted by: Anubis
did you try an overlay plot?

Nothing about that comes up when I ask the office clip. (Didn't they say they removed him from Office XP?)

 

[Rogue]

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.

 

[PCMarine]

I don't know how you could do that in Excel, but I'm pretty sure the program "Graphical Analysis" can do that.

 

[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?

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.

 

[RaynorWolfcastle]

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?

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

 

[Rogue]

That's what we're here for, to make everyone feel dumb.