| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Graphs?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Graphs?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Graphs?
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Graphs?
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Graphs?
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Graphs?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| For graphs how do i put a line of best fit? | New Users to Excel | |||
| Y Axis and line graphs | Charts and Charting in Excel | |||
| How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
| Q about Line Graphs | Charts and Charting in Excel | |||
| Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Hybrid Mode
