Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with a Task...any ideas? | Excel Discussion (Misc queries) | |||
Anyone else have any ideas?? | Excel Discussion (Misc queries) | |||
any ideas appreciated | Excel Worksheet Functions | |||
Any Ideas? | Excel Worksheet Functions | |||
Any Ideas | Excel Discussion (Misc queries) |