Chart data range
 

Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these cells
when i try to enter the data range it just uses the K18 and L18, i know its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John

Chart data range
 

This is an example where spending five minutes with the data will save hours
struggling with the component (in this case the chart) that uses the data.
You could spend five minutes setting up another range where a single
continuous column of cells links to the various cells spread out on the
table that is apparently formatted to give a nice display. Such a single
column would make a chart so easily.

Given that five minutes is too long to spend to make the data right, you
could make the chart from the first continuous set of cells, then copy more
cells, select the chart, use Paste Special from the Edit menu, and paste the
cells as new points (not new series). This might tack the points onto your
series in the manner you'd like them to.

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


"sadman49" wrote in message
...
Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these cells
when i try to enter the data range it just uses the K18 and L18, i know
its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John

Chart data range
 

Your correct in what you say but when your boss wants it set out in that way
there is not alot i can do but work with what i got but thanks anyway.

"Jon Peltier" wrote:

This is an example where spending five minutes with the data will save hours
struggling with the component (in this case the chart) that uses the data.
You could spend five minutes setting up another range where a single
continuous column of cells links to the various cells spread out on the
table that is apparently formatted to give a nice display. Such a single
column would make a chart so easily.

Given that five minutes is too long to spend to make the data right, you
could make the chart from the first continuous set of cells, then copy more
cells, select the chart, use Paste Special from the Edit menu, and paste the
cells as new points (not new series). This might tack the points onto your
series in the manner you'd like them to.

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


"sadman49" wrote in message
...
Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these cells
when i try to enter the data range it just uses the K18 and L18, i know
its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John

Chart data range
 

Listen, worksheet space is cheap. Keep the attractively formatted display
range, and put the suitable-for-charting data somewhere else, linked to this
data but where it doesn't distract the pointy-haired guy. Make your chart,
and if the boss questions it, explain that doing it this way sacrifices a
few cells or even a whole worksheet (a few bytes, and a 200GB hard drive is
under $100 bucks, so let's approximate it as free), in favor of making you
more productive by (5 minutes)/(1 hour) times your hourly pay plus benefits.

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


"sadman49" wrote in message
...
Your correct in what you say but when your boss wants it set out in that
way
there is not alot i can do but work with what i got but thanks anyway.

"Jon Peltier" wrote:

This is an example where spending five minutes with the data will save
hours
struggling with the component (in this case the chart) that uses the
data.
You could spend five minutes setting up another range where a single
continuous column of cells links to the various cells spread out on the
table that is apparently formatted to give a nice display. Such a single
column would make a chart so easily.

Given that five minutes is too long to spend to make the data right, you
could make the chart from the first continuous set of cells, then copy
more
cells, select the chart, use Paste Special from the Edit menu, and paste
the
cells as new points (not new series). This might tack the points onto
your
series in the manner you'd like them to.

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


"sadman49" wrote in message
...
Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets
just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these
cells
when i try to enter the data range it just uses the K18 and L18, i know
its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John