• 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


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

charting with different data


New Member
I need to compare two data sets in a line chart (I'm figuring the line chart is the best thing to compare two different data to see if there is a correlation, but let me know if it's not). My question is that the two data sets are in different formats--one is a percentage and the other is a number. I'm trying to see if the number increases then does the percent increase as well by displaying it in a chart. Because the data is in different formats, it doesn't really help with the trend if that makes sense. My number is in thousands and my other data is in percent. I can reformat my number? Or the line chart isn't a good choice to display this trend?

Thanks for your help!
Never mind...I just found something about creating multiple combination charts with varying values. If you find something else, let me know...