Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Due to low reputation point i am not able to include the picture.

I am trying to make u guys understand what i am asking for:

I had created a report. And that Report contains these fields and values:

  Name, YTDPlan, Actual, YearPlan
  Rev ,  4418  ,  4410 ,  24069

I have included the first row of this report, for that i have to create a line graph. Can anyone please tell me what fields should be taken on which axis.?

share|improve this question
Only you (or your client) can decide what dimension you want on which axis (though date/time values are usually on the x-axis). In any case: why not try the various options and see what gives you the desired result? – Jeroen Apr 22 '12 at 18:46

This really depends on what you want your graph to show (i.e. trending, inconsistencies, over time, over categories, etc.). Some additional context would be helpful.

Looking at what you provided my first thought would be to show the data trending over time where one line represents "Actual" and the other "YTDPlan". This would show an "actual vs. plan" comparison. Using this assumption as an example, I would plot these 2 fields on the x-axis. You can limit what you show over time in your query or a report parameter. SQL Server Reporting Services (SSRS) will auto-create the values for you for the y-axis once the report is run (SSRS does this by analyzing the min and max bound values of your x-axis data).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.