|
Charts in Excel
Does anyone know if there is a limit to the number of items you can
have on the x-axis of a chart in MS excel? Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). Thanks! |
Charts in Excel
What type of chart? Explain what steps you are taking. Is the x-axis set to
constant min/max or to automatic? From Help (specifications) Feature Maximum limit Charts linked to a worksheet Limited by available memory Worksheets referred to by a chart 255 Data series in one chart 255 Data points in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 Line styles 8 Line weights 4 Area patterns (screen display) 18 Total area pattern and color combinations (color display) 56,448 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ... Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). Thanks! |
Charts in Excel
On 7 Jan, 14:45, "Bernard Liengme" wrote:
What type of chart? Explain what steps you are taking. Is the x-axis set to constant min/max or to automatic? From Help (specifications) * * * Feature Maximum limit * * * Charts linked to a worksheet Limited by available memory * * * Worksheets referred to by a chart 255 * * * Data series in one chart 255 * * * Data points in a data series for 2-D charts 32,000 * * * Data points in a data series for 3-D charts 4,000 * * * Data points for all data series in one chart 256,000 * * * Line styles 8 * * * Line weights 4 * * * Area patterns (screen display) 18 * * * Total area pattern and color combinations (color display) 56,448 best wishes -- Bernard V Liengme Microsoft Excel MVPwww.stfx.ca/people/bliengme remove caps from email wrote in message ... Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? *Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). *Thanks!- Hide quoted text - - Show quoted text - Hi there. Thanks for your response. I am trying to update an existing bar chart (which currently shows only 7 items across the x-axis--I'd like it show 9). I went to source data--series. When I try to update the values in which I would like to edit (which are also housed on my data sheet), it only allows me to choose 7 of the 9 percentages that I'd like to incorporate. |
Charts in Excel
Hi,
Another limit is the series formula length, which is around 1024 characters. This can be quickly exceeded if the chart is based on non-contiguous ranges. Cheers Andy wrote: Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Charts in Excel
On 7 Jan, 15:08, Andy Pope wrote:
Hi, Another limit is the series formula length, which is around 1024 characters. This can be quickly exceeded if the chart is based on non-contiguous ranges. Cheers Andy wrote: Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? *Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). *Thanks! -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info hmmm. I do not think that I am violating any of the above rules/ limitations. Thoughts on how to circumvent this issue? |
Charts in Excel
|
Charts in Excel
Double click the axis, click on the Scale tab, and enter 1 where it says
Number of Categories between Tick Mark Labels (even if it says 1 already, click in the box and press Enter). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). Thanks! |
Charts in Excel
If it's formula length the only work around is to reduce it's length.
This can be done by placing your chart data in a contiguous block. If you want to email the file, off NG, I will take a look. andy AT andypope DOT info Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info wrote in message ... On 7 Jan, 15:08, Andy Pope wrote: Hi, Another limit is the series formula length, which is around 1024 characters. This can be quickly exceeded if the chart is based on non-contiguous ranges. Cheers Andy wrote: Does anyone know if there is a limit to the number of items you can have on the x-axis of a chart in MS excel? Right now I am being limited to 7 (e.g. when I try to add more than 7 values to my data series, I am unable to so). Thanks! -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info hmmm. I do not think that I am violating any of the above rules/ limitations. Thoughts on how to circumvent this issue? |
| All times are GMT +1. The time now is 04:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com