Re: Graphing 20 months of data into 2 lines

You might find it helpful to use a pivot table to help with selection of the
categories. It can also help with splitting up by year.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"forest8" <forest8@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74FC767B-2F32-4CD2-B446-8C077FEB0DC4@xxxxxxxxxxxxxxxx
The chart grows every month and eventually may contain at least 5 years of
data. As well it contains several hundred rows with categories. I want
to
be able to choose which categories to graph.



"MartinW" wrote:

Hi Forest,

First up Apr 2006 to Dec2007 is 20 months not 30.

Secondly you say,
I want to use my current data without manipulating the data into 1
column
for Apr06 to Mar 07 and so on. Is this possible?

Why? What is wrong with manipulating your raw data into something
usable and then plotting your chart from there. It's not hard to create
formulas that assess your raw data the way you want.

Please post more detail of what you have and what you are trying to
achieve.

Regards
Martin


"forest8" <forest8@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:134803BE-2B19-44AF-9F56-69B26C6A5E08@xxxxxxxxxxxxxxxx
I currently have 30 months of data from Apr 2006 to Dec 2007 arranged in
columns B to V.

I want to have a line graph which shows Jan to Dec and compares two
years,
that is, last year would be Apr 06 to Mar 07 as 1 line and current year
would
be Apr 07 to Dec 2007. When I add Jan 2008, the line will automatically
add
the new month of data.

I want to use my current data without manipulating the data into 1
column
for Apr06 to Mar 07 and so on. Is this possible?







.

Relevant Pages

  • Re: Graphing 20 months of data into 2 lines
    ... for Apr06 to Mar 07 and so on. ... What is wrong with manipulating your raw data into something ... I want to have a line graph which shows Jan to Dec and compares two years, ... I want to use my current data without manipulating the data into 1 column ...
    (microsoft.public.excel.charting)
  • Re: [Fwd: Re: [patch] Real-Time Preemption, -RT-2.6.9-mm1-V0.4]
    ... > fewer useless info, the quicker the human brain can read it. ... > to generate a nice graph out of it needs a different format.) ... Then one can process this raw data to ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Creating waveforms
    ... Steve Fryatt ... which I can then process and feed into Tau to graph them; ... raw data as an 8-bit unsigned waveform, but I don't think that was what ...
    (comp.sys.acorn.apps)
  • How to retain graph from report
    ... I am able to successfully generate graph in a report based on some x ... and y values and show the raw data on this report as well. ... since applied a macro that exports this report into Excel. ...
    (microsoft.public.access.reports)
  • DSWTFM: Paying attention to your own graph
    ... I have the raw data from which the graph is said to be sourced. ... of complete openness, I'll be repeating that raw data on here, along with ... So the first question I have to ask you is, given the two facts above, have ...
    (alt.radio.digital)