Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have 25 data points and all of them show up in my graph. However, the data
value for the last point does not show in the graph, although the source data reflects the proper 25 cell values. I've tried to re select the source data, and the chart keeps dropping the last data point. Any help would be greatly appreciated! Valerie |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
What first jumps to my mind is that the 25th value appears as a number but is
actually formatted as text. For this check Format /Cells/Number tab. Another reason may be that he value is out of range (so plotted but outside your plot area). For this: check your axis scales. Third: maybe yr 25 data points start with 0 (so 0-24, not 1-25) which may hv put you on the wrong foot (x-axis shows data point @24), although in fact all 25 points are there. Hope either of these three solves it. GL, Henk "Valerie" wrote: I have 25 data points and all of them show up in my graph. However, the data value for the last point does not show in the graph, although the source data reflects the proper 25 cell values. I've tried to re select the source data, and the chart keeps dropping the last data point. Any help would be greatly appreciated! Valerie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |