Search results for query: *

When I highlight my data and start the chart wizard to make a scatter plot, excel never properly (or logically) assigns the cell references in the series tab (step 2). Instead I have to manually enter the cell ref for each entry for the x and y axis. Is there a different way to do this...I have...

I have created a scatter plot w/lots of pts and instead of having different shapes for each entry I want them all to be a black circle. Is there an easy way to format all the points at once?

How can I do a cumulative addition in excel? ie: the first entry would be 3.2 , the second one would be 3.2 + 3.9, the third one would be 3.2 +3.9+ 4.4...etc. There is no sequence to the numbers, it is just a cumulative sum of the previous column. Any easy way to do this without having to do...

I would like my 'Initiative' combo box (cboInit)to look up the appropriate record once an initiative is chosen. How do I go about doing that?

I've been able to get a selection from the 'Division' combo box (cboDiv) to change the options available in the subsequent 'Initiative' combo box (cboInit). The problem is that the initiative box doesn't keep updating everytime I choose a different division...it only changes once I close out of...

Is this a good table design or am I setting myself up for disaster in the future? I have set up two access tables: Projected and Actual. Each table has exactly the same fields, except one is projected and the other is actual (example: Revenue/Actual Revenue; Cost/Actual Cost). There are also...

I created a query based on 2 tables: Projected and Actual. Both tables are exactly the same, having all the same fields, except one is for projected values and the other is for actual values. The query is set to calculate the difference between actual and projected for all the fields (ie...