If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Problem

Misticles · 2010-08-11 19:14:58

I am trying to make graphs to represent data. Data (text) ranges from 5 up to almost 5000 entries. I just cannot get Excel to do what I want. I want to express x as a % of y in graphical form. I have attached an example. I want to express column b as a % of column c. Or even represent it... column b goes to say 500 on a…

11-08-2010 7:14pm

#1

Misticles

Registered Users, Registered Users 2 Posts: 13,746 ✭✭✭✭

Join Date: July 2005

Posts: 13260

I am trying to make graphs to represent data.

Data (text) ranges from 5 up to almost 5000 entries.

I just cannot get Excel to do what I want.

I want to express x as a % of y in graphical form.

I have attached an example.

I want to express column b as a % of column c.

Or even represent it... column b goes to say 500 on a bar chart whereas column c goes up to 5000.

Thanks

0

Comments

#2 16-08-2010 5:40pm

Seth Brundle

Moderators, Politics Moderators Posts: 41,240 Mod ✭✭✭✭

Join Date: April 2003

Posts: 40185

Soln. #1: add a new column which calculates the percentage and chart on that.
Soln. #2: use a calculated field within a pivot chart.

0