Thread: Chart Ideas???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Judi Judi is offline
external usenet poster
 
Posts: 54
Default 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