INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Chart issue

Chart issue

(OP)
hello,
i have a report with a chart.
In X axis i have the MONTHS (given range of Dates FROM-TO).
In Y i have values.

My problem is when there is no data for some months then in X axis the month does not appear.
I want it in my chart to show all months, even there is no data for some months.

Do you know how can i solve this?

Thanks in advance,
Panagiotis

RE: Chart issue

Hi,

Generally there are two types of charts with respect to the x-axis: Category and Value.

With Category axis each item has its own slot, so to speak. The position on the axis is simply the next slot in the sequence. In your case each month that has data. And the missing months simply had no data. BTW 0 is data but NOTHING is well, ER, uh, NOTHING.

With Value axis the x POSITION on the axis is relative to the scale of the axis. So if You had y-axis values for month 1, 4 and 5, then there would be no y-axis values for 2 & 3, but you would still see 2 & 3 displayed on your chart.

My guess is that you have a Category chart. You need actual data (0) for the missing months, which is usually done by performing an outer join to a calendar to include all months.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close