• 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.

Search results

  1. S

    Plot a stacked column chart with multiple sets of data

    Thanks again Guido! I actually like the last one the most. Much appreciated!
  2. S

    Plot a stacked column chart with multiple sets of data

    Thank you both! I agree with Guido that it does not convey a great message and is very cluttered. However, I was asked by our President to chart the data presented to him and could not make it work. Once again, I very much appreciate your expertise!
  3. S

    Plot a stacked column chart with multiple sets of data

    Hello Everyone, I have searched for a solution to this but I am struggling trying to find a way to plot comparative data on one chart that shows revenues by major customer over several years. More specifically, I am trying to plot each year on a stacked column that shows each of the major...
  4. S

    Relative comparison of two data sets?

    Thank you both again for your incite and expertise. Much appreciated!!! Take care. Scott
  5. S

    Relative comparison of two data sets?

    Hello Everyone, I am trying to figure out a way to determine/show the relative improvement of a productivity KPI compared to the increased travel volume on the roads. I have attached a simple example of the type of data I would like to compare. The issue that I am trying to present is that...
  6. S

    Return a dynamic reference to a cell beside a pivot table

    Wow! That is excellent. Thank you very much Bosco!!! Scott
  7. S

    Return a dynamic reference to a cell beside a pivot table

    Hello again Everyone, I am trying to find a way to return values in cells beside a pivot table. The data set that the original pivot table draws from does not contain certain data so it is accumulated in a second worksheet. What I want to know is if I can return specific values to match up...
  8. S

    Compare data from one list to another if there are duplicates within the same column

    Thank you all for your awesome responses. I appreciate you taking the time to help me out with your advice. Much appreciated!
  9. S

    Compare data from one list to another if there are duplicates within the same column

    Hello Everyone, I would appreciate some assistance in trying to identify (highlight preferably) unique values in two columns but exclude values that are duplicates in a column. I did search the site but could only find a solution if there are no duplicates in the same column. Any help is much...
  10. S

    Text formatting & leading dots

    Thanks to all of you for your advice and suggestions. I copied SirB7's code tried to run it in Excel 2010. What I found was that the entire cell content was bolded again and not just the intended piece. I do appreciate your time and efforts though. Regards, Scott
  11. S

    Text formatting & leading dots

    Hello Excel Gurus I am trying to format text with multiple formats and leading dots. I have not been able to figure out if it can be done. I have attached a sample worksheet for reference. If anyone know the trick here, I would be most appreciative. Thanks in advance! Scott
  12. S

    Match multiple columns in multiple lists

    Thanks again Hui! For everyone else, the sumproduct function did the trick. I appreciate you time and efforts.
  13. S

    Match multiple columns in multiple lists

    Hello I am trying to match two columns in one list with two columns in a second list. What is the formula to verify this? For example, list 1 has column A(address), column B(bin size) and list 2 has column D(address) and column E(bin size). In list 1, the address could have multiple bin...
Back
Top