• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ascending Order Formula

C

comp764

Member
Hi
I was wondering if some could help me out here. I have a couple of charts showing the same data, one in a column chart and the other in a bar chart. I have them linked to a (control form) combo box.

What I am having problems with is the bar chart. The bar chart is showing the data in Descending order. I am using the following formula to get vaules in Ascending order: =SMALL($C$8:$C$19,ROWS(G$8:G21)) but I don't know how to get the months to change with the percentage values.

I uploaded a spreadsheet with a example of what I am trying to do.

Thank you in advance for your help.
 

Attachments

  • Percentage Rates.xlsx
    27.9 KB · Views: 4
Hi ,

I am not sure I have understood your problem.

Can you check your file now , and give your feedback ?

Narayan
 

Attachments

  • Percentage Rates.xlsx
    28 KB · Views: 12
Wow! Thank you! That's exactly what I needed. I spent a whole day searching the internet to find a salutation.
Can't believe it was the simple.

Thanks again for your help, it's greatly appreciated
 
You must log in or register to reply here.
Back
Top