Thread: Chart Help
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart Help

Each row corresponds to a column position. For the column positions that are
a solid column, the other columns should be blank or zero. For the column
positions where you have stacks, then you have more than one nonzero entry.
It should be arranged something like this:

Solid 1 Solid 2 Solid 3 Stack 1 Stack 2 Stack 3
Solid 1 [data]
Solid 2 [data]
Solid 3 [data]
Stacked [data] [data] [data]

Solid 1 [data]
Solid 2 [data]
Solid 3 [data]
Stacked [data] [data] [data]

Solid 1 [data]
Solid 2 [data]
Solid 3 [data]
Stacked [data] [data] [data]

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sound Into Words" wrote in
message ...
Jon,

Your graph is close to what I'm looking for but every column in your graph
is a stacked bar graph. I'm looking for 3 solid columns and 1 Stacked
column.

"Jon Peltier" wrote:

Clustered-Stacked Column Charts
http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sound Into Words" <Sound Into wrote in
message ...
Does anyone know how to combine a line bar bar graph with a stacked bar
graph?

Basically the graph would have 4 bars and then the 5th bar would be a
stacked bar while the rest of the bars remain solid. Here is a link to
a
picture I posted on the UK forums. So far everyone has told me it is
impossible, but I don't believe it is.

http://www.access-programmers.co.uk/...092#post721092

Please Help!!

I have tried everything I could think of, but I ended up using
microsoft
expression design.