×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-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!
  • Students Click Here

*Eng-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.

Students Click Here

Jobs

Progressive progress charts

Progressive progress charts

Progressive progress charts

(OP)
I have a chart with months on X axis

On the Y axis are monthly values which are generated by a formula.

I want to insert the formula for the whole year but truncate the chart at the latest month. i.e. At end of July the chart should only show values to end July but the formula would extend to the end of the year (showing blanks).

At the moment the chart line dives down to zero for August.

I have tried if statements and inserting "-" for zero values but that did not help.

Without deleting the formula is there a simple way of truncating the graph?

Stephen Argles
Land & Marine
www.landandmarine.com

RE: Progressive progress charts

Just set the max value for the X-axis.  Right-click on the axis - it's on one of the tabs.

RE: Progressive progress charts

(OP)
MintJulep,

Thanks for the suggestion but I was hoping to have the X axis read January to December all the time and I also have 20 graphs so I wanted to avoid changing them each month.

Stephen Argles
Land & Marine
www.landandmarine.com

RE: Progressive progress charts

You were on the right track with using zero or "-", but try using NA() in the formula for future dates.  Excel should not chart NA() values.

RE: Progressive progress charts

Or using named ranges.

RE: Progressive progress charts

(OP)
Panars

Perfect solution.

Thank you

Stephen Argles
Land & Marine
www.landandmarine.com

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 Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

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

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


Resources