graphing by group

T

Tim Pasma

I have 10 individuals in 5 groups.
I would like to graph the individuals but keeping them
within their groups. When I try to graph it ends up as 10
groups.
I would also like to make each group of individuals a
different colour.

Thanks,
Tim
 
B

Bernard Liengme

Hi Tim
In Step 2 of Chart Wizard make sure you have Series by Rows or Series by
Columns correctly selected.
If you groups are in different columns us Series by Columns other wise use
Series by Rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook - Catgorizing emails by names 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Work Budget Salary vs Real Time Salary 0
Visio to Excel 0
Weekly Report 2
Plotting Graph with dynamic table 3
Make Y-axis values correspond to x- axis value 1
Bar Graph 1

Top