Recent content by Powhatan Jack

I think what you need is to format your axis with fixed values instead of auto. I tried that and the chart did not change as it did before. Jack

Narayan, I am only adverse to VBA because of the security aspect. Beside, I lot of what I see from Chandoo is formula based and I enjoy seeing the possibilities. Anyone else have any ideas? Jack

Well done, Chandoo! Powhatan (the county where I live) Jack

I did a little "playing around" with the data on "water" and came up with the following. It is not exactly how you described it in your link, but, well, you will see. The data tab contains the data. I used column sums to accumulate the totals as I move "up" the pie charts. The three charts...

I'm sorry, I did not follow your last post. As far as changing "Series 1", right-click on the chart and select "Select Data..". On the left of the "Select Data Source" window, you will see "Series 1" and an Edit button above it. Click the Edit button and enter this in the "Series name" box...

Here is the way I would do it. Let's say, to expand your example, you had the values 3, 25, 32 in A2:C2. In A1, place this formula: =A2&"("&TEXT(ROUND(A2/SUM($A$2:$C$2),2),"0%")&")" The meat is the TEXT(ROUND(A2/SUM($A$2:$C$2),2),"0%"). This will divide A2 by the sum of the three columns...

Narayan, Although I certainly appreciate your work on this, I was hoping for something a little smoother. The error messages when not choosing a certain number of teams for the series is exactly what I was hoping to avoid. I had setup dynamic ranges for each series in the production sheet...

I hope this works. I am new to this forum and to Dropbox. https://www.dropbox.com/s/c61c8a4m52npiwd/Example.xlsx

I have a spreadsheet with weekly values in columns for teams in rows. I want to be able to select which teams and weeks to chart based ranges entered in four cells. I have gotten dynamic ranges to work as far as the number of teams (bars in the cluster on the chart) but cannot figure out how...