×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

Problems formatting simple bar chart

Problems formatting simple bar chart

Problems formatting simple bar chart

(OP)
Hello

I am reproducing a report, currently written in Access/ Excel, in Info7.

I'm having trouble achieving what I'd have thought was a fairly simple reproduction of an aged debtors balance chart.

The original Excel report has 2 columns : a label for the period (from Current Mth to 12Mths old) which forms the x-axis labels and the corresponding dollar values on the y-axis. The data is presented both as columns of data and graphically and I want to keep this format.ie

Current                    100
Last                        50
2Mths                        0
3Mths                        0
4Mths                      700
etc

Charted as:

800 |
    |
700 |                    |
    |                    |
600 |                    |
    |                    |
500 |                    |
    |                    |
400 |                    |
    |                    |
300 |                    |
    |                    |
200 |                    |
    |                    |
100 | |                  |
    |_|____|_____________|________________________

     Curr Last 2Mth 3Mth 4Mth etc

Each period balance is actually a seperate database field starting at "aged_balance#01" for the current month through "aged_balance#13" for 12 Mths old and I have re-labelled them Current, Last etc through to 12 Months old.

I can't get the period labels to appear as x-axis labels whether I either group the report by each period OR whether I have each period plus its label in the details section.

If I add a legend I get "aged_balance#01", "aged_balance#02" etc etc as the legend label which looks ugly and I can't edit it, and I don't get the option to add my custom labels (Current Mth, Last Mth etc etc).

Is there any hope of achieving what I want by any other method?

Sorry for the sloppy representation of the chart but you get the picture. Whats bread and butter in Excel seems impossible in Info7.......



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! Already a Member? Login


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