How to add multiple measures in a combination chart?

[actcognosuser]

How do i add multiple  measures to show on a bar graph?like student count
and professor count based on school location?

legend is the school location...

for location A i should have two bars-student and proffesor count..

similarly for location B,C,D,E.

Thanks in advance!

[MFGF]

Hi,

Drop School Location into the categories, and drop both Student Count and Professor Count into the Series.

Regards,

MF.

[actcognosuser]

Thanks MFGF.I also have a year in the category.

Is it ok to nest the location too?Should i use bar/combination?????

for location 1 , the total count should be stacked on student count.|||ly for locations 2,3,4,5.

[MFGF]

It all depends what you want to see in your chart:

If you want a bar for each measure for each location within each year, drop Year into the Category box then drop School Location below year within the Category box.

If you want a bar for each measure for each year within each location, drop year intothe Category box then drop School Location above year within the Category box.

And so on...

Can you advise exactly what layout you are looking for?

MF.

[actcognosuser]

 Thanks for the reply MFGF.

How do u attach a file to post?I have a mock up in a word document.

[MFGF]

Thanks for the reply MFGF.

How do u attach a file to post?I have a mock up in a word document.

If you expand the Additional Options below the input dialog when replying, there should be an Attach field.  I think the max file size is 5Mb.

MF.

[actcognosuser]

Thank you .Please find attached file MFGF.

[MFGF]

Hmmm.  I can't see any attachments. Wonder if the site is allowing them?  ???

[actcognosuser]

Can i get ur email or is there a way to paste the image?

[actcognosuser]

Hi MFGF,
            There are 3 bars .one for each location A, B, C.Each bar has two sections.-One for
student count ,one for total. to make a comparison of student count versus total.Then these 3 bars are repeated
for every year .as in series ..(x axis).I want the location as the series.

Hope i dint make it more complex.!

[MFGF]

Hi,

If each location has only one bar, do your measure values (Student Count and Total) stack on top of each other within the bar?

If so, use a Stacked bar chart, drag Year into the category box, drag Location below it into the category box, then drag Student Count and Total into the series.

Regards,

MF.

[actcognosuser]

Thank u MFGF .It worked.Is there a way to space out the location after every year.the chart looks too busy.I
did not find any options to space them out?Do i need to use any variables?