Chart Help

  • Thread starter Thread starter Sound Into Words
  • Start date Start date
S

Sound Into Words

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/forums/showthread.php?p=721092#post721092

Please Help!!

I have tried everything I could think of, but I ended up using microsoft
expression design.
 
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.
 
Ed

Thanks for the reply.

The Graph I'm looking for is kind of like Jon's graph except I'm looking for
3 solid columns and 1 stacked column. All of Jon's columns are stacked on
his graph
 
Sound Into Words said:
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.
Click to expand...

Can you create a stacked bar graph and just enter zeros for the stacked
portion of the first 3 columns?

_dennis
 
The Graph I'm looking for is kind of like Jon's graph except I'm looking for
3 solid columns and 1 stacked column. All of Jon's columns are stacked on
his graph
Click to expand...

Yes, but have you noticed they're stacked with *different* clusters?

The basic insight that leads to being able to do these is that a "solid"
column is just a cluster of one, or a cluster in which every element but
one has the value *zero*. Once you grok that, it all becomes obvious.
 
Del,

Thanks for the reply.

I thought about what you wrote, and that it might be able to work, but just
to get some clarification I will give you some variables:
1. y axies = "1-1000"
2. x axies = "Week 26 - Week 28" (3 series)
The first series would contain 4 solid columns(or a range between "1-1000")
and one stacked column which would make of 3 different ranges(colors) of
"1-1000" The other 2 series would be the same but just a different set of
data.

So would this scenario work with the "Stacked Cluster Graph" This would be
part of a report that is ran once a week.
 
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
 
Back
Top