Chart Ideas???
 

Hi,

I have some data that looks like this (unlikely that it's going to translate
well the way it's pasted, but you probably get the idea):

5/23-5/30 5/30-6/7 6/7-6/13 6/13-6/26 6/26-7/18 7/18-7/31
NVM 0% 0% 3% 0% 0% 0%
MCIC 0% 3% 3% 1% 0% 0%
CRC 0% 33% 0% 0% 0% 0%
MTIF 0% 0% 5% -1% 0% 1%
MSIA 0% 0% 3% 0% 0% 2%
CEB 0% 0% 0% 0% 0% 0%
MCP 0% 4% 0% 0% 2% 12%
MCDR 0% 0% 1% -9% 0% 0%
MCDD 0% 0% 4% -10% -5% 0%
MCPCU -77% 333% 3% -3% -5% 0%
MCS 0% -3% 2% 0% 0% 1%
MCR 0% 0% 33% 25% 20% 0%
MCB 0% 0% 5% -1% 1% 0%
MCBKP 0% 5% 0% 0% 3% 2%
MREU 0% 0% 1% 0% 25% 1%
CEPCU1 0% 0% 1% 0% 0% 0%
CEPCU2 0% 0% 2% 0% 2% 0%
TMC 0% 0% 0% 0% 3% 0%
LCC 0% 0% -2% 0% 4% 0%
HPCU 0% 1% 2% -1% -13% 1%
PAMB 0% 0% 0% 0% 0% 0%
GID 0% 0% 0% 2% 4% 0%
SPCU 0% 0% 0% 0% 6% 0%
PBC 0% 3% 5% 2% 0% 0%
SDS 0% 0% 0% 0% 0% 0%
BCB 0% 1% 0% 3% -1% 0%
PFC 0% 0% 0% -4% 0% 0%
DPJ 0% 0% 7% -3% 0% -3%
AIS 0% 0% 7% 141% 3% -1%

I'm looking for a good way to graph it. I'm having a hard time really
showing the data well, because it's a little spread out. Any ideas? I've
tried a line graph, but the lines closer to 0 are all jumbled, because the
chart has to go high enough to accommodate 141% and 333% type entries.

So, I'm open to ideas.

Thanks,

~judi

Chart Ideas???
 

Havve you tried logarithic scale. right click chart and coose custtom type -
Logarithmic.

"Judi" wrote:

Hi,

I have some data that looks like this (unlikely that it's going to translate
well the way it's pasted, but you probably get the idea):

5/23-5/30 5/30-6/7 6/7-6/13 6/13-6/26 6/26-7/18 7/18-7/31
NVM 0% 0% 3% 0% 0% 0%
MCIC 0% 3% 3% 1% 0% 0%
CRC 0% 33% 0% 0% 0% 0%
MTIF 0% 0% 5% -1% 0% 1%
MSIA 0% 0% 3% 0% 0% 2%
CEB 0% 0% 0% 0% 0% 0%
MCP 0% 4% 0% 0% 2% 12%
MCDR 0% 0% 1% -9% 0% 0%
MCDD 0% 0% 4% -10% -5% 0%
MCPCU -77% 333% 3% -3% -5% 0%
MCS 0% -3% 2% 0% 0% 1%
MCR 0% 0% 33% 25% 20% 0%
MCB 0% 0% 5% -1% 1% 0%
MCBKP 0% 5% 0% 0% 3% 2%
MREU 0% 0% 1% 0% 25% 1%
CEPCU1 0% 0% 1% 0% 0% 0%
CEPCU2 0% 0% 2% 0% 2% 0%
TMC 0% 0% 0% 0% 3% 0%
LCC 0% 0% -2% 0% 4% 0%
HPCU 0% 1% 2% -1% -13% 1%
PAMB 0% 0% 0% 0% 0% 0%
GID 0% 0% 0% 2% 4% 0%
SPCU 0% 0% 0% 0% 6% 0%
PBC 0% 3% 5% 2% 0% 0%
SDS 0% 0% 0% 0% 0% 0%
BCB 0% 1% 0% 3% -1% 0%
PFC 0% 0% 0% -4% 0% 0%
DPJ 0% 0% 7% -3% 0% -3%
AIS 0% 0% 7% 141% 3% -1%

I'm looking for a good way to graph it. I'm having a hard time really
showing the data well, because it's a little spread out. Any ideas? I've
tried a line graph, but the lines closer to 0 are all jumbled, because the
chart has to go high enough to accommodate 141% and 333% type entries.

So, I'm open to ideas.

Thanks,

~judi

Chart Ideas???
 

Joel - The log axis will choke on the zeros and negatives.

Judi - What do you want to show in your data? The few points that tower over
(or under) the others? A column chart may be your best bet, with a scale
from -100% to +350%. Alternatively, a scale of -5% to +10% includes more
than 90% of the values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Joel" wrote in message
...
Havve you tried logarithic scale. right click chart and coose custtom
type -
Logarithmic.

"Judi" wrote:

Hi,

I have some data that looks like this (unlikely that it's going to
translate
well the way it's pasted, but you probably get the idea):

5/23-5/30 5/30-6/7 6/7-6/13 6/13-6/26 6/26-7/18 7/18-7/31
NVM 0% 0% 3% 0% 0% 0%
MCIC 0% 3% 3% 1% 0% 0%
CRC 0% 33% 0% 0% 0% 0%
MTIF 0% 0% 5% -1% 0% 1%
MSIA 0% 0% 3% 0% 0% 2%
CEB 0% 0% 0% 0% 0% 0%
MCP 0% 4% 0% 0% 2% 12%
MCDR 0% 0% 1% -9% 0% 0%
MCDD 0% 0% 4% -10% -5% 0%
MCPCU -77% 333% 3% -3% -5% 0%
MCS 0% -3% 2% 0% 0% 1%
MCR 0% 0% 33% 25% 20% 0%
MCB 0% 0% 5% -1% 1% 0%
MCBKP 0% 5% 0% 0% 3% 2%
MREU 0% 0% 1% 0% 25% 1%
CEPCU1 0% 0% 1% 0% 0% 0%
CEPCU2 0% 0% 2% 0% 2% 0%
TMC 0% 0% 0% 0% 3% 0%
LCC 0% 0% -2% 0% 4% 0%
HPCU 0% 1% 2% -1% -13% 1%
PAMB 0% 0% 0% 0% 0% 0%
GID 0% 0% 0% 2% 4% 0%
SPCU 0% 0% 0% 0% 6% 0%
PBC 0% 3% 5% 2% 0% 0%
SDS 0% 0% 0% 0% 0% 0%
BCB 0% 1% 0% 3% -1% 0%
PFC 0% 0% 0% -4% 0% 0%
DPJ 0% 0% 7% -3% 0% -3%
AIS 0% 0% 7% 141% 3% -1%

I'm looking for a good way to graph it. I'm having a hard time really
showing the data well, because it's a little spread out. Any ideas?
I've
tried a line graph, but the lines closer to 0 are all jumbled, because
the
chart has to go high enough to accommodate 141% and 333% type entries.

So, I'm open to ideas.

Thanks,

~judi