Formatting X Axis On Scatter Plot Chart

Jul 27, 2007

Attached is a chart I am trying to create. So basically, I originally used a line chart but it didn't have the flexibility of the scatter chart, but i am having a very hard time formatting the X axis. First of all - I would like the line in the middle at the 0% point to actually go to the bottom so that the x axis labels aren't in the middle of the graph. Second the x axis labels aren't showing up correctly. They should be quarters: 1Q:02, 2Q:02, 3Q:02, 4Q:02... Finally, how can I show the correlation between these two data points plotted - the R-squared. THANKS!!! Auto Merged Post;I actually was able to figure out most of what I asked. What is remaining: how do I calculate the R-Squared on the chart? Isn't there a way to do it automatically in excel on the chart.

View 3 Replies


Label Chart Scatter Plot Markers

Jun 4, 2008

In the attached spread sheet I have created a scatter plot. How can I label each of the markers with its appropriate label from Column A - the Company Ticker. When I right click to show data labels it brings back the incorrect column. Also is there a way once the labels are brought in to put them in the circle and so that the chart doesn't look too clumped together.

View 2 Replies View Related

Plot Each Selected Row Range As Series In Scatter Chart

May 16, 2008

I need to plot multiple series in a scatterplot. The problem is that the number of series is user-defined. And also, the number of data poitns in each series is different. I've looked it up already, but a lot of the examples i've seen don't account for the fact that I need to run through a loop and add series into my graph.
In other words, i need a way to select a certain range each time it runs through the loop, and add the data as a series into the chart. Also, the user enters how many series there are, so I use that as a counter

View 9 Replies View Related

Scatter Plot Chart With Multiple Series From Selected Range

Jan 31, 2009

What I want to achieve is a script that would create a new scatter plot of multiple series from a selected block of cell. I found a thread that was similar but what is different from my data is that my x values are different for each series.

The format of the data is in the following format, the first series will the first x,y pair, the 2nd series would be the second x,y pair. I don't know if it'll be an issue but one thing is that the date might be different lengths. For instance, the 3rd series, only has 4 data points, whereas the other series contains 6 data points?


So essentially, is there a way I can have the script say, select your range, and then graph the selected range as a scatter plot?

View 9 Replies View Related

Conditional Data Point Colors For Scatter Plot Chart

May 5, 2008

I have to create a chart XY Scatter plot in excel. I have to differentiate the data points color based on the another column "category". Now I can change the data points color manually. Since the number of points is huge, is it possible to color the data points based on a column?

View 5 Replies View Related

Change X Axis Of Scatter Chart

Jun 1, 2009

The attached file has a scatter chart in which all of the data is properly displayed except the X axis. How can I get my X axis to reflect the data I have selected?

View 2 Replies View Related

Format Chart Plot Series/Axis

Jan 16, 2007

im having problem formatting my graph.

chart type = line.

I have 1 series of data, which is N values vs. Time.

Time however, is specified by specific dates. The graph is not putting a plot point accorrding to the date corresponding to the N value.

Example values:

date:____1/1/05 _______ 5/7/05 _____ 8/13/05
n value: __55 ___________ 22 _________ 11

I want the chart to reflect the time between the dates and put a plot point (n value) under each date listed and connect with a line.

View 9 Replies View Related

Formatting Axis Of Bubble Chart

Aug 2, 2013

I created a bubble chart whose x-axis and y-axis show every 10th value between 0 and 100 (i.e. 0, 10, 20, 30...). The axes intersect at (50, 50) to create 4 quadrants.

I want to erase/hide the values on the axes (i.e. the axes will no longer show 0, 10, 20, 30... and at the same time, the bubbles will still be in the same place) to create 4 blank quadrants and make my bubble chart easier to look at.

View 4 Replies View Related

Scatter Plot With Line Best Fit

Feb 2, 2008

I got the following table and it generates a random number either 1 or 0 (win or loss)

trade win/loss Account value
0 10,000
rand() 1 0 9,800
rand() 2 1 11,000
rand() 3 1 12,000
rand() 4 0 11,500

Each time I press F9, the Account value changes because the win/loss is generated randomly. Assuming, I press F9 100 times, how do I create a scatter plot chart with a best line fit for all the account values. I know how to create the scatter plot but how do I save all the values everytime I press F9.

View 9 Replies View Related

Conditional Formatting Percentage Axis For Thermometer Chart?

Jun 11, 2014

I currently have a thermometer chart in Excel 2013 that I set up with percentages along the Y-Axis. The thermometers are showing spending based on a budgeted number. Currently, the project is over-budget so I have adjusted the thermometer scale to go far beyond 100%.

I would like to have the percentages past 100% show in red along the lefthand side.

View 2 Replies View Related

Excel 2010 :: Formatting Chart Axis Values?

Oct 8, 2011

Why the recorded code doesn't work? I recorded the code below to format the Y-axis values of a chart with the recorder.

With Selection.Format.TextFrame2.TextRange.Font
.NameComplexScript = "Arial"


View 6 Replies View Related

Conditional Formatting Of Chart Based On Category Axis Value

May 24, 2005

I am trying to format the colour of a column chart based on the value of the x axis (not the y axis value). Firstly I need to know if it is possible. Secondly I would appreciate any hints / VBA code that could be useful.

View 4 Replies View Related

Labeling Points On Scatter Plot

Oct 8, 2013

I have the scatter plot below and I'd like to get the team names to show beside each point.

View 3 Replies View Related

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)



[Code] .......



Regression Statistics

Regression Statistics

Multiple R

[Code] ....

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

View 1 Replies View Related

Macro To Edit Scatter Plot?

May 15, 2014

I have a list of interest rates and durations and was hoping to be able to add in a third dimension of data which would either increase the size of the plotted points or change their colour depending on the rating. So have the normal scatter plot then save me from editing each point manually.



Interest Rate


[Code] .........

View 1 Replies View Related

(x,y) Scatter Plot Label Vba Implementation

Sep 2, 2004

I have a scatter plot with 150 points closely grouped. Enabling the label option clutters the graph. A cleaner way would be to hoveri the mouse over a data point and pop-up a box displaying it's value (x,y) as well as a label contained in an adjacent column.


The default functionality is that when the mouse hovers over a particular point the yellow pop-up box appears withData set label
Data point name "x"
Data point (x,y)
and one can choose to show "label-name-point" or just "point" by accessing the Tools-Options_Charts menu item. What I would like instead is to hover the mouse over a particular point and get the yellow pop-up box with the following functionalityData set label
Data point name "label"
Data point (x,y)
where the label is contained in an adjacent column in my data spreadsheet.

I read a post by Andrew Poulsom that stated it is probably not possible to customize the yellow pop-up baox and then offered some vba code to allow a mouse click to bring up a label. I was wondering how to implement this code in the spreadsheet. Also, does the graph have to be embedded in the worksheet "as object in", or can I use "As new sheet"?

View 9 Replies View Related

Creating Scatter Plot With Mean/ SD Error Bars

Apr 24, 2014

I need to create some vertical scatter plots ie where all the y values are in the same line, and also to put on the mean and standard deviation error bars, like the example I found below. I have managed to plot the scatter by giving all the y values in each group the same x value, but I don't know how to proceed.

View 4 Replies View Related

How To Change XY Scatter Plot Data Labels

Jan 22, 2014

I need to label points on an XY scatter plot with a different set of label points than those provided by simply assigning data labels (don't need series name or x and/or y values displayed but an additional field of data). I can't use an add in (work machine) and would like to do this without using macros.

The project has 4 fields

plot# type x y

I need to label the XY points for each series (type) by their plot #. The attached image/file shows what I'm looking for (added plot # labels manually for sake of display, in reality there are >2000 plots so I cant do it manually.

View 1 Replies View Related

Draw Parallel Line Through Scatter Plot

Oct 6, 2009

Currently we have data that is plotted to a scatter plot along with an already defined line. Next, with a straight edge we attempt to draw a line parallel to the already defined line through the scatter points of data. We basically find two points that give us the best fit to the original line. What I attempted to do was calcualte the slope of the original line and then the slope of each combination of two points in the data set. I then subtracted the slopes, found the minimum difference and thought that would give me the line most parallel to the original. This doesn't seem to work. I'm at a loss, any advice?

View 8 Replies View Related

Calculate Volume From Two Datasets On Scatter Plot

May 8, 2012

I have two different data sets that I have plotted using XY(Scatter) w/ smooth lines. Is there a macro or sub that will calculate the volume or area between where the two data sets cross?

View 3 Replies View Related

Use CurrentRegion As Source Data For Scatter Plot?

Mar 1, 2013

I have a spreadsheet in which the amount of data is not predictable. There are always a different number of rows and columns in this spreadsheet. I need to be able to grab the data that is in it starting with B1 and going to the last row and column with data and put it into a scatter plot. The code that is currently in my macro is as follows:

ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
ActiveChart.SetSourceData Source:=Range("ForChart!$B$1:$J$1000")

Note: ForChart is the name of the sheet where the data is housed; I have other sheets in this macro.

I know that the last line is the problem. While I figured out how to select only the data I need, when it goes to put it into the chart, it's still using an absolute reference and I don't want that. There are sometimes more columns than J and fewer rows than 1000. I want that data range to be whatever CurrentRegion selected. Is that even something that Excel can do?

View 3 Replies View Related

Creating Custom Legend For XY Scatter Plot?

Sep 30, 2013

I need a way to make a customized legend for a scatter plot, is there any way to do that through VBA? I have a scatter plot with some points highlighted green, and some points grey depending on the user selection and need to be able to create a legend based on what the user selects (e.g. Green - Category B, Grey - Category A, etc.).

For some reason I can't get Excel to rename points on the scatter, so I feel like there is only one option: create custom images and align them correctly with labels on the plot.

View 2 Replies View Related

Data Labels Points In Scatter Plot

Jun 19, 2008

I am attaching the Excel File along with this mail. In chart there is data points have been mentioned in scatter plot like (38,15 etc) Instead of these points I want the names that I have mentioned in column A2:A9. I used to make lots of charts related to this and it is very diffilcult for me to manually punch all these names and most importantly the thing is that I cant download the software available on due to some issues can you give me the VBA code for this which will automatically paste these names only I have to change is the data range and its very urgent................ASAP

View 7 Replies View Related

How To Add Date Labels And Have Different Color Points For Scatter Plot

Sep 15, 2014

What I'm aiming to be able to do is have a scatter plot that displays date labels for each point as well as distinguish the points by year by using different colors. I found a VBA code for scatter plot date labels and I also realize that (for me at least), the easiest way to distinguish the years by color would be to separate them with a logical statement and let the chart do the rest of the work by categorizing them as separate data ranges. However, I tried to do this with the VBA code that I found and it expectedly did not work. I'm not sure if it's an easy fix to just add more "xvalues" columns in the code or if what I want to do here is even possible.

Format and Code for the Date Labels:
Date Time
Rainfall (mm)
24 hr RDII Volume (L/ha/day)


View 1 Replies View Related

Attach Labels With Names To The Points In A Scatter Plot

Jul 18, 2006

how to attach labels with names to each point in a scatter plot

View 9 Replies View Related

Extract Scatter Plot With Connected By Smooth Lines Points

Jul 25, 2012

I have a couple of points, and when i do a scatter plot with connected by smooth line plot, it seems like excel does a bezier splines interpolation. I am wondering am i able to extract the data plots from the data chart?

for example if i have

X - Y
0 - 5
180 - 0
360 - 5

I would like to have all datas of Y from X (0 - 360 degree every degree).

View 9 Replies View Related

Excel 2008 :: How To Add Data Labels For Scatter Plot Coming From 3rd Column

Jul 29, 2014

I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column.

I have 3 columns of data: (A,B,C)
Labels, X values, Y values

When I select the Data Source for the Chart, there is a greyed out box for Category X axis labels, which is where I remember such information going in PC versions of Excel I used to use.

From the formatting palette, the only options to select for labels add the values of column B, but I need the reference from column A.

I'm not familiar with macros or visual basic. How to add these labels? This is Mac, Excel 2008.

View 3 Replies View Related

Labeling X-axis On X Y Scatter?

Apr 16, 2014

I've got two columns of information plotted against one another in an x,y scatter. I need the x-axis to reflect each of the 42 numbers I've added in the column and not a preset or fixed range of numbers. (I need to see the actual number that I assigned each x-plot point on the x-axis and not on the plot point itself).

View 2 Replies View Related

Excel 2010 :: Parsing Data From Text File To Create Scatter Plot?

Jan 11, 2014

I have a text file which is attached as "rawdata". It contains records of something (let's call it temperature) at different times on different days. My goal is to display a graph of temperature versus time so that I can visually analyze trends. I have hundreds of these files, all of different lengths. it is very important that I automate this process as much as possible.

Detail: (Here I describe what I have done so far; if this is inefficient or unnecessary, feel free to tell me) I open Excel 2010, click File, Open, and select the file that I want to parse. It is a TXT file, so the Text Import Wizard comes up. For step one, I select Fixed Width. I select File Origin: MS-DOS (PC-8). On step 2 of the wizard, I create column break lines to place all dates in the far left column. The next column contains the first column of numbers before the first dash (-). The next column contains only the dash - I will later select "ignore this column" to eliminate them. The next column contains the time stamps. I continue adding column breaks in the wizard until all of the data are parsed into columns in the same manner.

In step 3, I format the first column as "date (DMY)". The columns with the dashes I select "do not import". Everything else is "general". I click "finish", and the resultant workbook is attached, called "import".

Now, as to what I want to do: I want to display the "temperatures" as a graph vs a date/time axis. The reason I find this difficult is because the temperatures and times are not in neat columns, but are in 4 columns that go in a left-to-right and top-to-bottom progression and are broken up every few lines. (I am interested only in numbers that are displayed immediately to the left of a time-stamp. Therefore, the "record #"s should be ignored. We can delete the rows that say "record #" if can be done automatically.)

View 3 Replies View Related

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.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved