Line Graphs?

[WH99]

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?

 

[Jon Peltier]

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/Pub0009/LPMArticle.asp?ID=246

- Jon

 

[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,
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?

 

[Jon Peltier]

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]

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.

 

[Jon Peltier]

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

 

[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!!!!

 

[Jon Peltier]

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

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

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

- Jon