Search results for query: *

The reason I prefer a scatter is that you can see each occurance of a sale within the various projects over time to look for pricing changes. I'm not concerned with total volume of sales in dollars and currently track the count (absorption) on a seperate bar chart tied to a pivot table. I know...

Skip, Hope the surgery went as well as could be expected and that your recovery is on the fast track. The code worked fantastic with the exception that if two units sell on the exact same day it is returning the sum of the $/SF instead of independent results. Is there a tweak that will allow...

I must be missing something. I'm not seeing how the individual sale dates of units can correctly correspond with the projects when the dates are in a single column and the projects are in a single row but seperate columns. Enlightenment appreciated. Mike

Just made my first post earlier today which you (Skip) promptly replied too. My father went the seed and radiation route a few years back and has been doing well since. I wish you well tomorrow and in the future. Mike

Hi Skip, A sample file is attached. This sample has 5 series. I have not had any success in getting chart wizard to auto ID each series (denoted by Project name). I had to add each series individually to create the adjacent chart. Any guidance on this is much appreciated...

I am wondering if there is a way to have an Excel chart with two or more series automatically detect and name each series from the data set by common text found in one of the data table columns. Pivot tables won't work since they do not allow use of a scatter chart, which best graphically...