## Excel graph

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

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

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

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

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

Is this for school?

TTFN (ta ta for now)

I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg

FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

## RE: Excel graph

Anyways, I have uploaded a image here. Hope, it will clarify my query.

Let me know if you can help.

Thanks,

Ankit

## RE: Excel graph

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

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

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: Excel graph

## RE: Excel graph

## RE: Excel graph

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