| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Possible to create line chart with values not in all time periods?
Is it possible to create a chart with lines connecting the values on a time
axis where there are NOT data points for each time period? For example, 30 days over which only 5 values occur. When I tried to add a line to a scatter chart nothing happened. I suppose I could create another series that uses the end points of the first series and simply fills in the values based on the slope between the two points but I'm hoping there is a better way. Many thanks for your assistance. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Possible to create line chart with values not in all time periods?
Go to Tools Options Chart tab, and choose the Interpolate option for how
to treat blank cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "CodeKid" wrote in message ... Is it possible to create a chart with lines connecting the values on a time axis where there are NOT data points for each time period? For example, 30 days over which only 5 values occur. When I tried to add a line to a scatter chart nothing happened. I suppose I could create another series that uses the end points of the first series and simply fills in the values based on the slope between the two points but I'm hoping there is a better way. Many thanks for your assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| line chart over time | Charts and Charting in Excel | |||
| Line chart zero values | Charts and Charting in Excel | |||
| How to create a line chart with two X-axes in Excel | Excel Discussion (Misc queries) | |||
| How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Hybrid Mode
