Prev: Find and Then Loop
Next: Converting a number (17 characters) to text (Scientific Notation)
From: MJ on 20 Apr 2010 13:06
I know there must be a relatively simple solution to my challenge, short of
creating a new series od data which is the sum of desired series.

Let's say that I have the following

02/13/2010 02/20/2010 02/27/2010 ...
0-30 $7,072,987 $5,990,448 $8,978,002
31-60 177,472 160,460 142,547
61-90 24,976 25,644 2,413

Rather than tracking two series (0-30 and 31-60) as two separate series on
my graph, I would like to track a NEW series called 0-60 which is the sum of
these two series:

02/13/2010 02/20/2010 02/27/2010 ...
0-60 $7,250,459 $6,150,950 $9,120,549
61-90 24,976 25,644 2,413

So how can I do this simply within the chart, without needing to do all of
the summation separately?

--

MJ
From: Don Guillett on 20 Apr 2010 13:33
How about a stacked bar chart

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"MJ" <MJ(a)discussions.microsoft.com> wrote in message
news:271D5A77-B7A7-498F-8D53-CF4964B6EFFD(a)microsoft.com...
>I know there must be a relatively simple solution to my challenge, short of
> creating a new series od data which is the sum of desired series.
>
> Let's say that I have the following
>
> 02/13/2010 02/20/2010 02/27/2010 ...
> 0-30 $7,072,987 $5,990,448 $8,978,002
> 31-60 177,472 160,460 142,547
> 61-90 24,976 25,644 2,413
>
> Rather than tracking two series (0-30 and 31-60) as two separate series on
> my graph, I would like to track a NEW series called 0-60 which is the sum
> of
> these two series:
>
> 02/13/2010 02/20/2010 02/27/2010 ...
> 0-60 $7,250,459 $6,150,950 $9,120,549
> 61-90 24,976 25,644 2,413
>
> So how can I do this simply within the chart, without needing to do all of
> the summation separately?
>
> --
>
> MJ

From: MJ on 20 Apr 2010 14:43
Don,

Had not thought about that one, but I did try it. While might be a dark
horse possibility lacking a different solution for the sum of the series
group, due to the volume ot tracking points and the size of the graph it
looses a lot in the rendering. I even looked at the stacked area and line
graphs.

This is one of those times that a single line graph is the most productive
representation.

If you, or anyone else, has a solution on how to come up with a Series
values formulas what will sum the series values, that is what I am looking
for.

Thank you for your suggestion.

--

MJ


"Don Guillett" wrote:

> How about a stacked bar chart
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett(a)gmail.com
> "MJ" <MJ(a)discussions.microsoft.com> wrote in message
> news:271D5A77-B7A7-498F-8D53-CF4964B6EFFD(a)microsoft.com...
> >I know there must be a relatively simple solution to my challenge, short of
> > creating a new series od data which is the sum of desired series.
> >
> > Let's say that I have the following
> >
> > 02/13/2010 02/20/2010 02/27/2010 ...
> > 0-30 $7,072,987 $5,990,448 $8,978,002
> > 31-60 177,472 160,460 142,547
> > 61-90 24,976 25,644 2,413
> >
> > Rather than tracking two series (0-30 and 31-60) as two separate series on
> > my graph, I would like to track a NEW series called 0-60 which is the sum
> > of
> > these two series:
> >
> > 02/13/2010 02/20/2010 02/27/2010 ...
> > 0-60 $7,250,459 $6,150,950 $9,120,549
> > 61-90 24,976 25,644 2,413
> >
> > So how can I do this simply within the chart, without needing to do all of
> > the summation separately?
> >
> > --
> >
> > MJ
>
> .
>
From: trip_to_tokyo on 20 Apr 2010 15:00
EXCEL 2007

Hi MJ.

I have just pu up a file for you at:-

http://www.pierrefondes.com/

Item number 97.

I have created a Pivot Table and Pivot Chart from the data that you provided.

You can toggle on / off what's in the chart by using the drop down in F2.

For your 0 to 60 day period I created a Calculated Item (as you can see).

Hope this helps you out.

If my comments have helped please hit Yes.

Thanks.





"MJ" wrote:

> I know there must be a relatively simple solution to my challenge, short of
> creating a new series od data which is the sum of desired series.
>
> Let's say that I have the following
>
> 02/13/2010 02/20/2010 02/27/2010 ...
> 0-30 $7,072,987 $5,990,448 $8,978,002
> 31-60 177,472 160,460 142,547
> 61-90 24,976 25,644 2,413
>
> Rather than tracking two series (0-30 and 31-60) as two separate series on
> my graph, I would like to track a NEW series called 0-60 which is the sum of
> these two series:
>
> 02/13/2010 02/20/2010 02/27/2010 ...
> 0-60 $7,250,459 $6,150,950 $9,120,549
> 61-90 24,976 25,644 2,413
>
> So how can I do this simply within the chart, without needing to do all of
> the summation separately?
>
> --
>
> MJ
From: MJ on 21 Apr 2010 10:57
Pierre,

I like your approach to my problem and I was looking at a pivot tablechart
as a possibility, but would require a major restucturing of our current
report format that our leadership is not prepared for at this time. I may
yet need to lead them down that path in the future, but right now they want a
simple brute force solution.

Thank you for your efforts and I will keep it handy as an example for the
future.

--

MJ


"trip_to_tokyo" wrote:

> EXCEL 2007
>
> Hi MJ.
>
> I have just pu up a file for you at:-
>
> http://www.pierrefondes.com/
>
> Item number 97.
>
> I have created a Pivot Table and Pivot Chart from the data that you provided.
>
> You can toggle on / off what's in the chart by using the drop down in F2.
>
> For your 0 to 60 day period I created a Calculated Item (as you can see).
>
> Hope this helps you out.
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
>
>
>
> "MJ" wrote:
>
> > I know there must be a relatively simple solution to my challenge, short of
> > creating a new series od data which is the sum of desired series.
> >
> > Let's say that I have the following
> >
> > 02/13/2010 02/20/2010 02/27/2010 ...
> > 0-30 $7,072,987 $5,990,448 $8,978,002
> > 31-60 177,472 160,460 142,547
> > 61-90 24,976 25,644 2,413
> >
> > Rather than tracking two series (0-30 and 31-60) as two separate series on
> > my graph, I would like to track a NEW series called 0-60 which is the sum of
> > these two series:
> >
> > 02/13/2010 02/20/2010 02/27/2010 ...
> > 0-60 $7,250,459 $6,150,950 $9,120,549
> > 61-90 24,976 25,644 2,413
> >
> > So how can I do this simply within the chart, without needing to do all of
> > the summation separately?
> >
> > --
> >
> > MJ
 |  Next  |  Last
Pages: 1 2
Prev: Find and Then Loop
Next: Converting a number (17 characters) to text (Scientific Notation)