By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Question About Column Charts

P: n/a
I have a column chart with two series:

1) Number Of Applications
2) Number of Completed Applications.

These are in a column format, so it looks like one bar, but colors
outline the two numbers.

Now I want to have a percentage (Completed Apps/Number Of Apps) over
the related column.

I tried added a third series, but it just doesnt look right.

Any other ideas?

TIA
Brian

Jan 4 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
BerkshireGuy wrote:
I have a column chart with two series:

1) Number Of Applications
2) Number of Completed Applications.

These are in a column format, so it looks like one bar, but colors
outline the two numbers.
Hi Brian,

You mean a stacked column, I think.
Now I want to have a percentage (Completed Apps/Number Of Apps) over
the related column.

I tried added a third series, but it just doesnt look right.
Remember charts/graphs are about displaying information in a graphical
fashion. To bring out obvious differences in data.

It seems to me that this third series you're adding is redundant; it
just quantifies what is apparant visually from the stacked graph.

You're already showing the contrast between applications and completed
applications with what you have. IMO, you need to either just leave it
as it is (perhaps the use of 100% columns might better display the
contrast between applications and completed applications) or do away
with the two series and replace it with just a SINGLE series showing
percentage.

8) In my experience, I often find I initially want to show too much
information on a graph. It's sometimes hard to limit oneself so as not
to overpower the medium one is using to present information.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Jan 4 '07 #2

P: n/a
Agreed - I offtered to have a seperate percentage graph, but the user
said "cant you just display a percent on top of the column."

They always think its just so easy.

-B

Tim Marshall wrote:
BerkshireGuy wrote:
I have a column chart with two series:

1) Number Of Applications
2) Number of Completed Applications.

These are in a column format, so it looks like one bar, but colors
outline the two numbers.

Hi Brian,

You mean a stacked column, I think.
Now I want to have a percentage (Completed Apps/Number Of Apps) over
the related column.

I tried added a third series, but it just doesnt look right.

Remember charts/graphs are about displaying information in a graphical
fashion. To bring out obvious differences in data.

It seems to me that this third series you're adding is redundant; it
just quantifies what is apparant visually from the stacked graph.

You're already showing the contrast between applications and completed
applications with what you have. IMO, you need to either just leave it
as it is (perhaps the use of 100% columns might better display the
contrast between applications and completed applications) or do away
with the two series and replace it with just a SINGLE series showing
percentage.

8) In my experience, I often find I initially want to show too much
information on a graph. It's sometimes hard to limit oneself so as not
to overpower the medium one is using to present information.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jan 5 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.