Scaling A Chart

R

robbbo

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a chart that is driven off a simple table that is filled in by the user. That table has up to 13 data points, but in most cases the table will only have 5 to 8 data points. If they have 8 the remaining data will be zero. I would like to chart to scale automatically to only have 8 points not all 13, so if I put a "If" formula in the series that plot the chart I can automatically control the amount of data point plotted. The series look like this: =SERIES('TREND ANALYSIS'!$B$24,'TREND ANALYSIS'!$C$10:$O$10,'TREND ANALYSIS'!$C$24:$O$24,1). I would like to replace the "O" with (if(O24=0,N,O)$24)

Carl Witthoft was helping me on this problem and he sent me this file which appears to do what I want, but I am struggling adapting it to my exact situation. He sent me this file to work with:

http://home.comcast.net/~cgwcgw/SelectData.xls.zip
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in a series for Charts 8
Dynamic Chart Scaling Error 0
Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
Creating Network Diagram using a Chart SW integration 0
Can't Include more than one data range in chart 0
"Add data" to chart menu command won't work 0
Converting a string into a filename 1

Top