# Auto Generate Table For Scatter Graph

Oct 31, 2006

after spending hours searching the forum, I begin to seriously doubt my ability to even formulate a suitable search question. My problem SHOULD be a known one, but I am unable to find any clues. Here we go:

I have made a pretty stright-forward forecasting model. It is used to calculate economics of a coal fuelled power plant (even though that shouldn't matter). The outcome is, among other things, a single number for Profit / MWh in Euros. There are several input data, such as fuel price, price for CO2 emission rights, operational expenditure, capex, etc.

My idea, then, is to lock all in-data parameters except ONE, then let this variable vary incrementally and then produce a new small table with a) the variable data (example: price for CO2 rights ranging from 10 to 50 Euro in 2 euro steps), and b) the resulting net profit in each case. Ideally, I wish to be able to chose which indata to lock and which to vary, i.e. solution need to have certain flexibility.

NB: The calculations are not that simple, i.e. I cannot use a simple formula - I need to use the exising output cell(s) to feed data.

How do I do this?

The outcome should be basically two rows with a suitable number of columns (or the other way around, two columns in X number of rows). The table will then be used to produce illustrative graphs.

I guess I could hard code a table by simply enter data, but heck, that's not the way to use Excel!

## Use Mail Merge From Table To Generate Data In Line Graph?

Jun 25, 2009

I want to generate a letter to parents that shares reading fluency data from an excel spreadsheet into a table and a chart. I got the info to post into cells in the table through mail merge. (sample below) Now I want to make a matching line chart to visually show the student's growth over time. I want the data on the chart to change according to the data I put in the cells in the table through mail merge. Is this possible?The data in the cell that says "Cory" and the "88, 100, 112" are placed in this table through mail merge. I want to now be able to take just Cory's information and display it as a line graph. If I highlight those cells and choose "insert a table" it doesn't work.

70-110 WPM85-120 WPM100-140 WPMCory
88100112

## Macro To Generate A Line Graph With Coloured Pointers And Lables Based On Table

Sep 30, 2009

column A = Date : 01/02, 07/02, 14/02, 21/02, 28/02 (x-axis : shows when the table is updated)
column B = project: x, x, x, x, ,x (name of the project and trend line)
column C = Delivery Date : 01/05/2009, 08/05/2009, 20/05/2009, 30/05/2009, 28/02/2009 (plotted on the graph)
column D = Status : Green, Amber, Red, Green, Blue (status of the project. the points should be the same colour as is described in the table)
column E = Comments: original, delay, supply, out of money, on track, delivered-wow! (these comments will pop up if the user holds the cursor over a point)

NB Y-axis scale : 01/01/2009 to 31/12/2009 with increments of 14 days. this will be the same scale used for all projects.

Date Project Delivery Date Status Comments
01/02 x 01/05/2009 Green original date
07/02 x 08/05/2009 Amber delay supply
14/02 x 20/05/2009 Red out of money
21/02 x 30/05/2009 Green on track
28/02 x 28/02/2009 Blue delivered-wow

So id like the macro to draw the line for project x based on the 'delivery date'. The points should be coloured according to the 'status' column and when you hover the mouse over the point the data lable will show up taking info from the 'comments' column.

Would it be possible to create a macro that will be able to generate this graph automatically. I have a few projects id like to do the same thing for.

## Make A Scatter Graph That Will Graph The Attached?

Mar 21, 2014

I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.

## Plotting On Scatter Graph

Jul 15, 2009

We have a special testing machine in the lab I work in, and it measures reflectivity from reflective vests etc. A special instrument takes a reflective reading and reports back a X and Y value which is used then as a co-ordinate and gets plotted on a graph.

The machine measures for 8 colours, and takes four readings, so for example the first color will be Flourescent Yellow. and then it produces 4 "X,Y" readings, which get plotted onto a graph, and joins all 4 points to create a box as shown in the link >> Graph with joined plots

This is a small capture of the spreadsheet with the values >> spreadsheet

Basically, I need to know how to take the values in columns X and Y, and then make it plot onto a graph as one point, and then join the four points for that one colour,

end result being the grapgh will have upto 8 boxes on it.

## Xy Scatter Graph Average Point With (+) Around It

Jun 8, 2014

I am supposed to make an xy scatter graph like the one drawn of paper. The average point need to have a "cross" around it. So far I can just plot the points. I have added the average point as secondary series. I just need to put the "+ sign or cross around" it.

## Coordinate Lines On Scatter Graph?

Jun 28, 2012

I have the following data points:

A
B

1
X
Y

2
0.18
0.52

[Code] ......

And can create a scatter diagram fine. However, I've been asked if it's possible to show on the graph, for each point a line to it's respective X and Y co-ordinate. For example, for row 4 (in red), on the same scatter graph, I'd like there to be two lines for this point,

Line1 drawn from (0.1, 0) to (0.1, 0.26) and
Line2 drawn from (0,0.26) to (0.1,0.26)

I know it's possible to overlap graphs in Excel, but I can't find how to achieve this with scatter plots

## How To Plot Scatter Graph With Regression

Nov 20, 2013

Given 100 samples, to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site.

x (social networking site)
y (study)
x^2

xy

6
4
36
16
24

[Code] .......

SUMMARY OUTPUT

SUMMARY OUTPUT

Regression Statistics

Regression Statistics

Multiple R
0.571423290877713

[Code] ....

So, I've got the coefficient of correlation equals to 0.57, how can I plot my scatter graph?

## Scatter Graph X Axis Grouping

Feb 28, 2008

I would like to graph the data shown below using a scatter graph. However, when I use the cart wizard it assigns numerical values to each data point and then plots the data accordingly. How can I get the scatter graph to group the assets with the same ratings together? Note, I don't want to have to assign values to assets with the same rating each time. I have attached the spreadsheet so you an see the problem.

## Change All Line Thicknesses In Scatter Graph

Jan 2, 2013

I have an XY scatter with 40 or so different lines displayed.I want to change the thickness of all of the lines. I dont want to have to try and select them individually and change them. Is there any way to do this? Perhaps changing the default thickness of lines for this type of graph?

## How To Prevent Large Scatter Graph Being Squashed

Apr 1, 2013

I am trying to plot a scattered line graph that contains nearly 4000 points on the y axis. The points represent a day. The x axis is the percentage belonging to that day. The problem that I am having is that the graph looks squashed together and the line is very thick because of this. One of the reasons for this is that a lot of the 4000 points have similar percentages so the line just moves a tiny bit. Is there a way that I can make the graph look more presentable?

The following is a picture of how it looks. You may need to enlarge it to see it properly.

## Start Scatter Line Data Later In Graph?

Jan 13, 2014

I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this other data which starts around half way into the time period. So all the data starts in June 2010... but this other data starts in June 2012.

## Category X Axis Labels On Scatter Graph

Apr 4, 2007

I have a set of data which I need to plot both unordered and ranked.

For the unordered (as is) data, a line graph is fine, as it gives the category labels along the x axis.

For the ordered data, i have a row with the ranking in, and then plot an xy scatter graph, so the values increase.

This obviously has the rank numbers along the x axis, not the corresponding category labels.

Is there anyway to force this? I know there are chart labelling add-ins on here, but our IT dept blocks the download.

The attched file is a very small example.

## Calculate Maximum Point On Curve From Xy Scatter Graph

Jan 18, 2008

I have put my values into a XY scatter graph but need to find the maximum point i.e when the gradient is zero. I am using visual basic to obtain my data and draw my graph.

## VBA Needed To Make Separate XY Scatter Graph For Each Group At A Time And Must Be Unique

Aug 19, 2014

I have 5 different groups for that i have to make XY scatter graphs and my data looks like this

XY
125
13
156
145
134
234
248
260
2102
2105
3125
3148
3198
3298
3245
4386
4369
4234
4465
4898
5902
5907
5345
5234
5209

now i want to make 5 different graphs one per each group. Now i am making them manually in excel but it is taking lot of time to format each graphs to get unique graphs. I am attching sample file and graph for better understanding.

## Auto Generate Passwords

Nov 24, 2008

Is there a way to auto generate passwords? I would like the result to start off with the word "cook" and end in numbers. Is this possible?

## Auto-Generate From Every 200th Row

Aug 30, 2013

I have a spreadsheet that has thousands of rows, but they only want every 200th row to be populated with said data values.

Is there a way that I can auto-generate those values separately?

In the one Attached, I don't have thousands of rows.

question.xlsx

## Auto Generate List

Feb 26, 2008

I have an event that is one week long (7 days), with three functions happening each day (7 days - 3 columns per day).

There are 11 groups with various number of possible attendees listed in rows. Attendees of a given function is indicated by entry of a 1 or 2 (attending partner), Blank = not attending.
I would like to show a list of the attendees for a given function by clicking or moving my mouse pointer on the event function column header.

The list would need to be automatically updated when the attendees status changes (entry or deletion of 1 or 2)

## VBA Auto Generate Unique IDs

Sep 29, 2013

I don't want to create a function to use within a cell, I need the Sub to run through a user form. I have a Userform to create a new account, and need to add a 6 digit unique identifier after a predetermined prefix ("T" for toddler, "Y" for youth, and "A" for adult). The constraints are that it cannot be duplicated (this is for multiple children registered within the company). I have tried using the GUID but having difficulty stripping characters and adding the prefix (this was my fix inclination).

## Auto Sort And Generate Sheets?

Dec 29, 2012

if it was possible to have Excel sort and then Auto generate a work sheet.

Once a week at work I get a report that is split up via our 3 digit office codes.

Once a week I manually sort the info and split the original sheet into separate sheets based on the office code and mail it to them.

Its is simple and repetitive but takes me half a day to do due to the size.

## How To Auto Generate Values In A Column

Jun 24, 2014

I have a user form into which data can be entered and is populated on the next sheet. The order ID is unique, is there way I can make the Order ID auto generated each time a record is entered instead of manually keying the number?

## Auto Generate Unique Number

Jun 23, 2006

VBA that autogenerates a unique number when a cell in excel is filled?

## Auto Generate Date Today But 3 Years From Now

Jul 10, 2013

I need to auto generate and populate some cells with todays date but three years from now.

## Generate Request ID With Date And Auto Number?

Jan 6, 2014

I facing a problem to generate request id number. Actually i need to generate id like example "RQ1013-01" where "RQ" is constant word, "1013" is month and year while "-01"is generated number. and every month i want the id number start from -00 back. thus in a month there is only 99 request is available.

## Auto Generate Save As Filename From Multiple Cell Data?

Sep 14, 2012

way for my engineers to save a field ticket with a certain name based on data from a couple of cells in the worksheet. Re: Auto generate "Save As" filename from text and tried to use some code posted in the thread, but I an still not having any luck.

What I want to do is create an active X button when clicked on, would save the workbook to a certain folder. I want the name to look like this:

SO1!M3_SO1!M6_SO1!H2.xls

This is what I have so far:

Private Sub SaveMe()
ThisWorkbook.SaveAs Filename:="C:usersdefaultdesktop" & Range("SO1!M3").Value & Format(Range("SO1!M3").Value, "text") & ".xls"
End Sub

Would I click "general" or "workbook" in VBA when I enter this code?

## Generate Sheet Automatically On Basis Of Auto Filter On Specific Column?

Apr 8, 2014

i want to generate sheet automatically from existing sheet applying auto filter on specific column. i attached the sample which 3000 rows actually i have more than one lac rows so i have to put filter on sub_div column and then copy and paste to another sheet and give the name of sheet like F21. i want to do automatically this provide vba code or function for this

## Auto Generate A Comment Box Based On A Cell Value That Has Variable Reference Cells

Jan 30, 2010

I have been given the following code and it works great. I now need to adapt it to the following scenario: In the attached sheet, the user has to select either, "Suburban" or "Squad" in row 5. If the user selects, "Suburban" I need this script to compare the values they enter in a given row to the value in column "B".
If the user selects, "Squad" I need this script to compare the values they enter in a given row to the value in column "C".

Look at row 48, for example. If the user enters, "Suburban" in cell D5 then the value they enter in cell D48 should equal "1". If it does not equal "1" then it should proceed with the adding of a comment. Conversely, if the user enters, "Squad" in cell D5 then the value the enter in cell D48 should equal "2". If it does not equal "2" then it should proceed with the adding of a comment.

## Creating A Graph By Auto Selecting A Set Of Data

Nov 12, 2006

i have a set of data range from B1 to K10 (10 cells all together).
and i created a graph by selecting from B1 - K10.
what i want is, if i key in range from 1-10 in A1, the graph will change based on the number i keyed in (from 1-10).

if i keyed in 5 in A1, the graph will auto select B1 to F1 and show data from B1 toF1

then if i select 6 in A1, the graph will auto select B1 to G1 and show data from B1 to G1

## Auto-Extending Graph/Chart Range

Aug 21, 2008

I have a Line Graph with 2 lines on it. Is it possible to write a macro to extend the range (Source range) of one of the lines ? I would also like to add a Data Label to the newly added point.

For e.g. If I have Line 1 graph only till 65, I want the macro to extend the range by one row to include 95 and also display a datalabel ......

## Auto Update Graph When New Data Is Added

Jun 9, 2006

I have a graph that is showing the date on "Y" axis and a value on "X" axis, when I add a new date and value to my data the graph does not update, it just shows the data when I first created the graph.

How do I get the graph to display the new data I entered ?

I created a line graph by clicking on the "A" in column "A" (Thats where my date is) then clicking on the "B" in column "B" (Thats where my values are) and clicking the create graph button then clicked finished.