×
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

# Excel graph

 Forum Search FAQs Links MVPs

## Excel graph

(OP)
Hello every one,

I am trying to create a graph where I want to draw RCC beam showing reinforcement. In simple words, I want to create a rectangle and place some number (Variable) of dots in it.
I could create a rectangle and place fixed number of dots but not sure how to fix it if number of dots are variable.

It would be great if someone could advise me in this regard.

Thanks and regards,
Ankit Gupta

### RE: Excel graph

Hi,

John Walkenbach has written a good reference, Excel Charts, giving examples of various obscure uses of Excel charts.

Check out plotting x,y pares in a scatter chart with lines, to form your rectangle, like ...
x  y
1  1
4  1
4  3
1  3
1  1


As for the variable number of points, which might be a second chart superimposed upon the first chart. Of course, the second chart must have no fill for the chart area and plot area, so the rectangle plot can display. Just use min and max functions to get the limits of your points in order to determine the limits of your rectangle plot.

Skip,

Just traded in my OLD subtlety...
for a NUance!

### RE: Excel graph

(OP)
Hello SkipVought,

Thanks for your reply.

Yes, I will refer reference material as mentioned.

Thanks for suggestions regarding rectangle plot. I already did it.

What I need to do now is to superimpose a second plot. For second plot, I have two co-ordinates and number of points/ dots/ circles to be filled between these to point. My problem starts when I have variable number of points/ dots/ circles. Otherwise, I can do it by defining co-ordinates to each points/ dots/ circles if no. of pints are fixed.

Thanks,
Ankit

### RE: Excel graph

It should be easy, but Excel XY charts have a "feature" that if any of the cells defining the coordinates for any line contain text (including ""), it decides it must be a line graph, and messes it up.

In this case it's quite easy to get around it. Decide the maximum number of points you will ever need, then enter a formula that will generate points at the required spacing. Then add a check that if the point is past the last bar it displays the last bar coordinates.

One other point; you don't need two graphs. Just one graph with two data ranges, and set the first one to lines only, and the second one to points only.

See attached file.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Excel graph

(OP)
Thanks Doug for your response.

Yes, I already tried what you suggested.

I was thinking if someone could suggest of some other way of doing it because I didn't want to engage so many cells.

And yes, I was doing it in one graph but two different data sets as you suggested in excel file. Sorry, my mistake in explaining the problem.

Thanks,
Ankit

### RE: Excel graph

I don't really see the problem with using the formulas on the sheet, but if you really only want to generate as many numbers as there are bars I think you will need some VBA. It would be quite straightforward, if you know VBA.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Excel graph

I did not read any sarcasm into IRstuff's reply.  Just a simple and economical form of words, offering a solution, and requesting more information if he had misunderstood things.

### RE: Excel graph

(OP)
I understand your point of view. Thanks you Doug.

### RE: Excel graph

(OP)
That's good Denial, if you do see things in such a positive way.

My bad. I prefer to see things in a more straight-forward way i.e., to see it as it is.

Anyways, I have got valuable suggestions from Doug. Many thanks to him and Eng-tips platform where I could discuss my excel problem.

Regards,
Ankit

#### 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!

Close Box

# Join Eng-Tips® Today!

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

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!

Already a member? Close this window and log in.