I have data that covers the whole year. I am trying to create a line graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show figures
for a particular month?
--
WH99

You could filter the data source, because a chart only shows unhidden cells
by default.

Or you could define dynamic ranges that include only the month in question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows unhidden cells
by default.

Or you could define dynamic ranges that include only the month in question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99

Jon,
I tried the dynamic chart and it works fine. Just one further question.
How do I add a trend line that marks from 0 to 48:00 hours in my graph.The
problem I am having on each graph the scale is different depending on how
many hours there are in a month. Is there a way to plot the same trend line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows unhidden cells
by default.

Or you could define dynamic ranges that include only the month in question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99

Is your trendline not supposed to include all the plotted points? A
trendline uses all points in a series. If you want a trendline for only the
data between 0 and 48 hours, you need to add a series (which could be hidden
using no line and no markers) and apply the trendline to this series.

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



"WH99" wrote in message
...
Jon,
I tried the dynamic chart and it works fine. Just one further question.
How do I add a trend line that marks from 0 to 48:00 hours in my graph.The
problem I am having on each graph the scale is different depending on how
many hours there are in a month. Is there a way to plot the same trend
line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows unhidden
cells
by default.

Or you could define dynamic ranges that include only the month in
question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line
graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99

I have the plotted line on the graph but I wish to add a additional straight
line starting at zero and crossing the 48 hour line. This way I can monitor
through the month if we are on track or not to attchieve 48 hours by the end
of the month.
--
WH99


"Jon Peltier" wrote:

Is your trendline not supposed to include all the plotted points? A
trendline uses all points in a series. If you want a trendline for only the
data between 0 and 48 hours, you need to add a series (which could be hidden
using no line and no markers) and apply the trendline to this series.

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



"WH99" wrote in message
...
Jon,
I tried the dynamic chart and it works fine. Just one further question.
How do I add a trend line that marks from 0 to 48:00 hours in my graph.The
problem I am having on each graph the scale is different depending on how
many hours there are in a month. Is there a way to plot the same trend
line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows unhidden
cells
by default.

Or you could define dynamic ranges that include only the month in
question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line
graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99

A line is defined by two points, right? Enter this into a range of cells in
your sheet (humor me and keep the top left cell blank):

Target
X1 Y1
X2 Y2

Copy the range, select the chart, and use Paste Special to add the data to
the chart as a new series. If necessary, change the added series to an XY
type, though for most purposes you probably should be using that chart type
already.

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


"WH99" wrote in message
...
I have the plotted line on the graph but I wish to add a additional
straight
line starting at zero and crossing the 48 hour line. This way I can
monitor
through the month if we are on track or not to attchieve 48 hours by the
end
of the month.
--
WH99


"Jon Peltier" wrote:

Is your trendline not supposed to include all the plotted points? A
trendline uses all points in a series. If you want a trendline for only
the
data between 0 and 48 hours, you need to add a series (which could be
hidden
using no line and no markers) and apply the trendline to this series.

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



"WH99" wrote in message
...
Jon,
I tried the dynamic chart and it works fine. Just one further question.
How do I add a trend line that marks from 0 to 48:00 hours in my
graph.The
problem I am having on each graph the scale is different depending on
how
many hours there are in a month. Is there a way to plot the same trend
line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows
unhidden
cells
by default.

Or you could define dynamic ranges that include only the month in
question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a
line
graph
for which ever month is selected. The data is layed out as
follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only
show
figures
for a particular month?
--
WH99

Sorry Jon, I dont understand! is there another way to explain. Iv tried
following your instruction with no luck. I might have to be taken through
step by step.
.........................sorry!!!!
--
WH99


"Jon Peltier" wrote:

A line is defined by two points, right? Enter this into a range of cells in
your sheet (humor me and keep the top left cell blank):

Target
X1 Y1
X2 Y2

Copy the range, select the chart, and use Paste Special to add the data to
the chart as a new series. If necessary, change the added series to an XY
type, though for most purposes you probably should be using that chart type
already.

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


"WH99" wrote in message
...
I have the plotted line on the graph but I wish to add a additional
straight
line starting at zero and crossing the 48 hour line. This way I can
monitor
through the month if we are on track or not to attchieve 48 hours by the
end
of the month.
--
WH99


"Jon Peltier" wrote:

Is your trendline not supposed to include all the plotted points? A
trendline uses all points in a series. If you want a trendline for only
the
data between 0 and 48 hours, you need to add a series (which could be
hidden
using no line and no markers) and apply the trendline to this series.

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



"WH99" wrote in message
...
Jon,
I tried the dynamic chart and it works fine. Just one further question.
How do I add a trend line that marks from 0 to 48:00 hours in my
graph.The
problem I am having on each graph the scale is different depending on
how
many hours there are in a month. Is there a way to plot the same trend
line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows
unhidden
cells
by default.

Or you could define dynamic ranges that include only the month in
question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a
line
graph
for which ever month is selected. The data is layed out as
follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only
show
figures
for a particular month?
--
WH99

Here is the procedure to add a horizontal line to a chart:

http://peltiertech.com/Excel/Charts/...orzSeries.html

It sounds like you want a sloped line, so your two points need different Y
as well as X values.

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


"WH99" wrote in message
...
Sorry Jon, I dont understand! is there another way to explain. Iv tried
following your instruction with no luck. I might have to be taken through
step by step.
........................sorry!!!!
--
WH99


"Jon Peltier" wrote:

A line is defined by two points, right? Enter this into a range of cells
in
your sheet (humor me and keep the top left cell blank):

Target
X1 Y1
X2 Y2

Copy the range, select the chart, and use Paste Special to add the data
to
the chart as a new series. If necessary, change the added series to an XY
type, though for most purposes you probably should be using that chart
type
already.

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


"WH99" wrote in message
...
I have the plotted line on the graph but I wish to add a additional
straight
line starting at zero and crossing the 48 hour line. This way I can
monitor
through the month if we are on track or not to attchieve 48 hours by
the
end
of the month.
--
WH99


"Jon Peltier" wrote:

Is your trendline not supposed to include all the plotted points? A
trendline uses all points in a series. If you want a trendline for
only
the
data between 0 and 48 hours, you need to add a series (which could be
hidden
using no line and no markers) and apply the trendline to this series.

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



"WH99" wrote in message
...
Jon,
I tried the dynamic chart and it works fine. Just one further
question.
How do I add a trend line that marks from 0 to 48:00 hours in my
graph.The
problem I am having on each graph the scale is different depending
on
how
many hours there are in a month. Is there a way to plot the same
trend
line
on different scale graphs?
--
WH99


"WH99" wrote:

Thank you Jon,
I shall first try the link you sent me then the filter one.
I shall let you know how I get on.
--
WH99


"Jon Peltier" wrote:

You could filter the data source, because a chart only shows
unhidden
cells
by default.

Or you could define dynamic ranges that include only the month in
question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a
line
graph
for which ever month is selected. The data is layed out as
follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only
show
figures
for a particular month?
--
WH99