Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Bar Graph
I am creating a simple bar chart and can't get past 14 data points using the
Control click method of selecting data points. Trying to type in the data point does not help. Any Ideas would be appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Bar Graph
Hi,
There is a limit to the length of the series formula. Using non consecutive cells vastly increased the length of that formula. Here is an example, firstly plotting the range A1:B10 =SERIES(,Sheet1!$A$1:$A$10,Sheet1!$B$1:$B$10,1) Now plotting only the even rows. So less data points but the series formula length is 90 characters longer. =SERIES(,(Sheet1!$A$2,Sheet1!$A$4,Sheet1!$A$6,Shee t1!$A$8,Sheet1!$A$10),(Sheet1!$B$2,Sheet1!$B$4,She et1!$B$6,Sheet1!$B$8,Sheet1!$B$10),1) Simplest way is to use consecutive cells and formula to build a set of charting data. Cheers Andy Cyberguy wrote: I am creating a simple bar chart and can't get past 14 data points using the Control click method of selecting data points. Trying to type in the data point does not help. Any Ideas would be appreciated. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graph problem | Excel Discussion (Misc queries) | |||
Excel graph as Value/picture | Charts and Charting in Excel | |||
How can I color a region of an Excel graph? | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
why is the y-axis label in the Excel graph always messed up? | Charts and Charting in Excel |