cluster

Hi, I have a similar issue, I want to create a formula that splits the data into deciles, or 10 equal groups of total rows but i also want it should divide the data in 10 groups or equal rows/people basis the city they belongs. For example, there are 300 rows for City1, 200 for city2, 400 for...

Can you make a cluster column chart with one series data charted on a secondary axis? For instance, I'd like to show x,000 new customers new customers by month with revenues of $YYY,000 for new customers by month. The issue is, the revenue would need to be plotted on a different axis because...

Guys, I have the graph above and would like to create a little base between each cluster. Is that possible? If so, how? Thanks!

Hi, I am trying to find a way to cluster cells together if their sum from left to right is over a certain threshold. But the ttl row of cells must be equal to the original. For instance, assume threshold is greater than 600 the original dataset is (in a row): 500, 200, 1200, 300, 300, 200...

Hey guys, This is my first post, what a way to pop the cherry! I have been a long time lurker and have been helped immensely by everyone here. I hope to give back as I become better with Excel. My questions are: I have a sheet with urls that have duplicate titles along with data on these...

I have a set of data -- emails sent per month for various users. So for example, in Nov-11 user "Bob" sent 3 emails. In Dec-14 "Bob" sent 25, "Susie" sent 15, "Michael" sent 5, and "Barbara" sent 10. I would like to have a chart that shows this, with the months being on the x-axis. I would...