Re: 2 X-axes in MS Graph

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

From: Ellinoz (Ellinoz_at_discussions.microsoft.com)
Date: 03/02/05


Date: Wed, 2 Mar 2005 14:43:06 -0800

Thanks for that Bill. How I and my colleagues laughed when we read your
advice. Not because it was in any way bad (before I get banned from this
community), but because we work in an investment bank, where the trend seems
to be towards complicating things as much as possible (including insisting we
use MS Graph for all their complicated financial data!!).

But thanks for setting my mind at ease that MS Graph definitely doesn't do
the job on that score. I thought I must be missing something incredibly
simple if it gave you the option for 2 x-axes without the option for
different x-axes!

"Bill Dilworth" wrote:

> You've given yourself the answer without realizing it.
>
> MS Graph is somewhat limited. Ummm. MS Graph is to limited as Everest is
> to mountain. Oh well, it isn't meant to be the end-all, top-of-the-line
> graphing program, it is just a helper app. It will graph out 99% of what is
> needed in PowerPoint slides.
>
> But, you said that Excel does what you want just fine. Why not cut and
> paste the graph from Excel into PowerPoint?
>
> Now, having said how, let's talk about if. If the graph is so complicated
> that it needs to be done in excel, you may want to re-think its use. Either
> present the information in a simpler format or break the information into
> smaller units. I've seen many presentations bogged down by graphs that try
> to incorporate all the data but don't clearly communicate anything. KISS
> principle in presentations. Simple facts. Strait forward ideas. Images
> (including graphs) that clearly illustrate.
>
> Maybe MS Graph will be enough if you simply your displayed data. One thing
> you may want to do is hand a copy of your graph to a co-worker (audience
> peer) and ask them what it shows. If they ask more than 2 or 3 questions
> without 'getting it' (the reason you are showing the graph), the graph may
> be too complicated to use in a presentation.
>
> --
> Bill Dilworth
> Microsoft PPT MVP Team
> Users helping fellow users.
> ===============
> Please spend a few minutes checking vestprog2@
> out www.pptfaq.com This link will yahoo.
> answer most of our questions, before com
> you think to ask them.
>
> Change org to com to defuse anti-spam,
> ant-virus, anti-nuisance misdirection.
> ..
> ..
>
>
>
> "Ellinoz" <Ellinoz@discussions.microsoft.com> wrote in message
> news:7CEA2770-B871-4DE6-8E05-B458C8A58D8A@microsoft.com...
> >I am trying to create a combination chart that has two y-axes and two
> >x-axes
> > with different values. This is because we have 2 columnar series on the
> > bottom x-axis, with 5 data points to be shown for 2001-2005E, and then a
> > line
> > series to go on the top x-axes, with roughly 1400 data points for daily
> > values over the same time period!
> >
> > I know this can be done in Excel but I can't seem to assign the second
> > x-axis values in the datasheet in MS Graph. Does anyone know if this
> > functionality is one of the missing pieces in Graph, or can it be done?
>
>
>



Relevant Pages

  • Re: Jerry - thank you. I guess I am mostly a teapartier.
    ... Bill keeps posting photos rather than original sources. ... Do you still believe "you" are the source of the graph, ... It is printed on your picture. ... is no problem with the economy ... ...
    (rec.gambling.poker)
  • Re: 4CT
    ... bill wrote: ... In fact, if you have a minimal counterexample G, deleting ANY vertex ... task of removing each of the 18 vertices in turn and reassigning the ... color the smaller graph ...
    (sci.math)
  • Re: Need Graph Isomorphism Algorithm De-bunked
    ... CNN's next headline may well be 'Graph Isomorphism in P'. ... keeping the lexically lowest graph connection matrix from each set of graphs that produced the same output. ... Both my version of your algorithm and my version of Bill Cox's now produce exactly the same set of 11,117 isomorphically distinct connection matrices for 8 nodes. ...
    (sci.crypt)
  • Re: graph theory proof hint needed please
    ... Bill J ... I thought the number of edges at any node would be n-1. ... The number of edges for the whole graph would be! ... Another hint would be great too! ...
    (sci.math)
  • 4CT
    ... Let graph G be a minimal counter-example to the 4CT. ... saying a task is impossible and proving it impossible is not ... Bill J. ...
    (sci.math)