Re: Best chart format to use?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Del, thank you for your response and lots of useful suggestions. Actually I
did come across a solution that was helpful, which i am happy to pass on.

Double click the 0 line (ie the Category axis) and that opens the Format
Axis box. Under "tick mark labels" select "low". This was perfect for my
given problem. Again, I appreciate your support. Cheers. Trish

"Del Cotter" wrote:

On Wed, 28 Nov 2007, in microsoft.public.excel.charting,
Del Cotter <del@xxxxxxxxxxxxxxxxxx> said:

1) abandon the positive/negative display and just go for a stacked
column chart with the Rec and Prob adding up to "Response". This was my
first idea, but I admit Jon's looks better (no problem with being able
to compare bars that don't line up). This way means you can just use X
axis labels.

Oh, there's another couple of options I forgot!

1.5a) format the Y axis scale so that the X axis crosses it at "-9999",
i.e. at the bottom of the chart.

1.5b) format the X axis so that, although it crosses the Y axis at zero,
the tick mark *labels* are "Low" instead of "Next to axis"

I've been assuming it's the category labels you're talking about, and
not the value of the numbers. The numbers are so small I think you
should trust people to use their eyes instead of showing the numerals,
or choose a table instead if you really prefer the integers, or use
Autoshape pictures to turn the stacked columns into countable stacked
shapes if you prefer graphics but want people to see the integers.

--
Del Cotter
NB Personal replies to this post will send email to del@xxxxxxxxxxxxxxxxxx,
which goes to a spam folder-- please send your email to del3 instead.

.

Relevant Pages

  • Re: Axis with 2 labels
    ... which is why I've been able to easily incorporate all kinds of axis effects ... (Also I learned computer charting on an HP plotter, ... compare them to the scale bars on a map, with the graph space analogous to ... Del Cotter ...
    (microsoft.public.excel.charting)
  • Re: Nice Craigslist responce
    ... I am thinking this guy thought Del was jerking him ...  Not defending that response he sent back which was uncalled ... I can see that position but it takes an immature adult to respond like ... Of course there are tons of ads I would love to slam on ...
    (rec.games.pinball)
  • Re: How can you backpedal from this?
    ... Del .net> wrote: ... I don't set around waiting on your response, Unkie. ... in a Usenet Firefight. ...
    (rec.sport.football.college)
  • Re: Nice Craigslist responce
    ... I am thinking this guy thought Del was jerking him ...  Not defending that response he sent back which was uncalled ... but he might have thought it was a scam or something when Del ... stories. ...
    (rec.games.pinball)
  • Re: How do I produce a graph with 2 x-axes and 1 common y-axis?
    ... Do I misunderstand what you're saying, Del? ... axis and leave the series on the primary X axis. ... I assume you mean a scatter graph. ...
    (microsoft.public.excel.charting)