If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart will not display complete series
I am charting in Excel 2002 (ExcelXP). I have a health diary datasheet
with a row for each day of the year and a column for weight, body fat %, hours of sleep, etc. I have set up a chart for Weight and use a dynamic range formula to create the series, which in this case goes from Jan 04 to the present date. That formula works correctly and selects the proper colum for the series. The named name for the series is set correctly in the chart. The chart displays the series correctly, but will not display further than 20 October. This is irregardless of whether the chart is on it's own sheet or not. (presently there are three charts, all embedded on a single sheet. When I first set up the dynamic ranges three days ago, I did get the entire range to display on each graph. Then I saved the workbook and got a message that "the picture was too large and would be truncated". Now, working on it again today, I am unable to get the entire series to display. I have even tried to create a new chart using the same dynamic range (again, correctly located by the formula) and that chart also stops at 20 October. I'm stumped. Anyone? Anyone? Buehler ? |
#2
|
|||
|
|||
Chart will not display complete series
Email me a copy of the file (my private email not the group) and I'll see
what can be done -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Doug" wrote in message oups.com... I am charting in Excel 2002 (ExcelXP). I have a health diary datasheet with a row for each day of the year and a column for weight, body fat %, hours of sleep, etc. I have set up a chart for Weight and use a dynamic range formula to create the series, which in this case goes from Jan 04 to the present date. That formula works correctly and selects the proper colum for the series. The named name for the series is set correctly in the chart. The chart displays the series correctly, but will not display further than 20 October. This is irregardless of whether the chart is on it's own sheet or not. (presently there are three charts, all embedded on a single sheet. When I first set up the dynamic ranges three days ago, I did get the entire range to display on each graph. Then I saved the workbook and got a message that "the picture was too large and would be truncated". Now, working on it again today, I am unable to get the entire series to display. I have even tried to create a new chart using the same dynamic range (again, correctly located by the formula) and that chart also stops at 20 October. I'm stumped. Anyone? Anyone? Buehler ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000; Display Series name in bar chart? | Steve Newton | Setting Up & Running Reports | 0 | April 16th, 2005 10:41 PM |
Adding new series to chart with two series types | Bill | Charts and Charting | 1 | November 14th, 2004 07:43 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Chart series split over more than 1 line - dont plot #n/a | allycat898 | Charts and Charting | 2 | March 22nd, 2004 10:11 AM |
add vertical line to floating bar chart, still trying | bbxrider | Charts and Charting | 6 | January 27th, 2004 11:42 PM |