Display 2 points of data
Hello, I am trying to figure out a good way to display 2 sets of data in a report. My data is this: I have a list of cars. And for each car I have a 1 to 10 rating. I also have a years owned. which can be anything. Such as 20 or 15 or 2. I have prototyped 2 charts in excel. the issue I have, is having 2 sets of different units. Do people think these charts are OK? Confusing? Is there a better way to display this information? thanks <iframe title ="Preview" scrolling="no" marginheight="0" marginwidth="0" frameborder="0" style="width:320px;height:139px;padding:0;background-color:#fcfcfc;" src="https://skydrive.live.com/embedphoto.aspx/Public/bars.JPG?cid=29e09069bb65159d&sc=documents"></iframe> <iframe title ="Preview" scrolling="no" marginheight="0" marginwidth="0" frameborder="0" style="width:320px;height:156px;padding:0;background-color:#fcfcfc;" src="https://skydrive.live.com/embedphoto.aspx/Public/line.JPG?cid=29e09069bb65159d&sc=documents"></iframe>
August 1st, 2011 2:35am

Hi my_drive, According to your description, you would like to display 2 different unites of data in a chart, right? Please correct me if my understanding is wrong. If inthat case, when you want to compare values that are of a different unit of measure, consider using the secondary axis so that you can plot two series on separate axes. The secondary axis is useful when comparing values that are of a different unit of measure. The secondary axis is drawn on the opposite side of the primary axis. The chart only supports a primary and a secondary axis. The secondary axis has the same properties as the primary axis. For more information, see How to: Plot Data on a Secondary Axis (Report Builder 3.0 and SSRS). If you have any question, please feel free to ask. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2011 11:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics