Plot Points On Top Of Another?

Sep 29, 2006

This may sound like a dumb question, but hang with me. I have two series in an xy plot. One is a line (withOUT markers) and one series is just markers (no line).

The line without markers is created in a way such that it forms a box and whiskers plot. The other series, are trial values that go into the box and whiskers.

I have desperately tried to get the second series (just points) to plot BEHIND the first series (line, no markers). Changing the series order does not work unless both series have lines. I have tried this in a variety of ways (including writing a macro which draws the markers first, and then the lines), but that doesn't work either!

View 7 Replies


ADVERTISEMENT

How To Plot Comparison Of Only 3 Points Against 9 In Graph

Mar 27, 2014

I'm stuck at a point in a graph that I am creating. Attached is as far as I have gone and now i'm having a gap on how to take the 2006, 2007 which is already in graph and add in how these years compare to guidelines visually in the same graph?

for instance ratings 1-9 are grouped in guidelines 1-4, 5-7 etc. How do i add in the 3 guides against each point? I have thought about adding a secondary axis but not how best to demonstrate the range of 1-4 to appear behind or above those points?

View 1 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

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 http://www.appspro.com 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)

[Code].....

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

Points Property Select Multiple Points

May 2, 2007

Is there a way of amending the following line of code so that it selects multiple data points in a data series in a chart (e.g points 14,15,16)?

ActiveChart.SeriesCollection(2).Points(14).Select

View 2 Replies View Related

XY Plot With Macro

Apr 19, 2006

In the attached sheet I have data in column F and G which I am plotting using the following

Sub evmplot()
Dim i As Integer
ThisWorkbook.Worksheets("sheet1").Activate
ActiveSheet.ChartObjects("EVM").Activate
ActiveChart.ChartArea.Select
For i = 1 To 15
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(i).XValues = "=sheet1!R[" & 5 + (i - 1) * 13 & "]C6:R[" & 17 + (i - 1) * 13 & "]C6"
ActiveChart.SeriesCollection(i).Values = "=sheet1!R[" & 5 + (i - 1) * 13 & "]C7:R[" & 17 + (i - 1) * 13 & "]C7"
Next i
End Sub

when I =1 , the sereis should be from R5c6:R17C6. But the first series in the plot is from R6C6:R18c6. Same is the case with other series also.

View 2 Replies View Related

Steps Graph - How To Plot

Jun 9, 2014

How to plot a step graph?

I have attached a drawing by illustrating the graph that I wish to plot.

Attached Image : jpg Capture.JPG‎

View 9 Replies View Related

Plot Dots On A Map With Data

Mar 30, 2014

I am planning on creating a map of a badminton court. I am hoping to record each hit of the shuttlecock with a dot on the map. Of course I want this to be inputted by data rather than manually inserting a circle shape and placing it in the correct location each time.

is there any way to do this in excel?

View 14 Replies View Related

How To Plot No Values In Bar Graph

Jun 3, 2014

I have a pareto for a manufacturing facility that has a list of nonconformists and their occurrences in columns K and L. My issue is since it is a running total for the year at certain times the values are 0 for the number of occurrences. This calculates fine, but the graph is very large and the failures are all located on one side instead of being evenly distributed. I am trying to get it to only plot for what has occurred and not have a bunch of blank values. To make it a little more complex I'm trying to avoid macros.. I can get them to show up blank just can't get the bar graph to resize itself to fill the chart.

View 3 Replies View Related

Creating Plot Using VBA - Add X Values?

Jul 9, 2014

I would like to make a histogram using excel. I have successfully made the bins and frequency functions. Once I want to add the x values, I get an error. There are many examples online, but I can't get it to work.

[Code] .....

View 1 Replies View Related

How To Plot X Axis Values From 00:00

Mar 15, 2012

I have data that starts from say, 17:50 hours. However, I would like the chart to start from 00:00 to 00:00 so it is a full 24-hour period. So up to 00:00 to 17:50 hours, it would be blank then the data will be plotted from 17:50. How do I do this? If I select the existing data from 17:50 and ask Excel to create a chart, the x axis starts from 17:50 (not 00:00).

View 4 Replies View Related

Plot Bin Average On Histogram

Apr 19, 2012

On Histogram, is it possible to plot Bin averages?

In my data there are two columns, 1) File Size 2) Months and then I have created Bin(months) like 0,6,12,18,24

I want to plot average file size in those Bins. For example I would like to plot what was the average file size in past 6 months, past 6-12 months so on.

View 1 Replies View Related

VBA To Plot Range From A Column

Mar 20, 2014

I have a column, call it column1, with thousands of numbers in it.

What I would like to do is get the min of this range, get the max of this range, and plot in a new column all numbers from the min to the max.

For Example

Column1
1
4
9
3
4
4
5
9
2
2

1 is the min, and 9 is the max

I want a new column, say columnNEW

1
2
3
4
5
6
7
8
9

Any clever way of doing this in VBA?

View 7 Replies View Related

Plot Data To Matrix

Aug 17, 2008

I have an Excel file with a sheet that has the following columns: Name, Activity, Start Date,
End Date. What I would like to do: I would like to create summary sheet with a calendar-like
matrix, with the names as rows, and dates as columns. I would then like to plot the activity in
the corresponding dates (based on the start and end date). Note: If there are schedule
conflicts, the conflict should show up in another row

- Is this even possible to do in Excel?

Source:
Name Activity StartDate EndDate
PersonA Vacation Jan1 Jan3
PersonA Office Jan4 Jan5
PersonA Field Jan6 Jan7
PersonB Vacation Jan1 Jan3
PersonB Field Jan4 Jan7
PersonB Office Jan5 Jan5
Summary:
Name Jan1 Jan2 Jan3 Jan4 Jan5 Jan6 Jan7
PersonA Vacation Vacation Vacation Office Office Field Field
PersonB Vacation Vacation Vacation Field Field Field Field
PersonB Office

View 9 Replies View Related

Plot Data By Criteria

Aug 1, 2006

on a macro or vb code that can search a date and shows everything related to the date? My problem is when i select a certain week for example first week of july. I need a macro of VB code that can find all the dates (or days) in an array of dates and data, which are arranged randomly, that falls in that week and copy them to another worksheet. I have attached the file with this message.

View 9 Replies View Related

Chart Won't Plot Dates

Dec 6, 2006

I have some weekly data that I need to produce a graph from (100% Stacked Column). Each time I create the graph using the dates as the x axis i only get a thin line which looks like it represents one day, the other space looks like it is for the other 6 days of the week. I know that you could add an apostrophe to the beginning of the date but this is to be an automated report.

View 9 Replies View Related

Not Plot Blanks In Chart

Oct 8, 2007

I have a set of data which indicates readings taken at different dates/times at varying intervals.

I want to create a chart where time is the X-axis but the usual charting feature would spread the data points at regular intervals. I want the data is spread out across the X-axis according to the actual timings.

I have a sample data in the file attached to this posting. There I showed the type of chart I want to see (which I achieved only by modifying the original set, Table 1. The modified set of data is in Table 2)

how to achieve this with the original table of data, Table 1.

View 9 Replies View Related

Plot By Region Chart

Jan 1, 2008

I am trying to figure out the best way to plot this data -- For each region, I want to plot December 2006 snowfall against December 2007 snowfall. So starting on row 12 to row 41 (in the attached file). First challenge: the dates are not aligned because it is using the retail calendar where 12/3/2006 is compared against 12/2/2007. How can I plot the snow depth for the Northeast for example? I can't just use a dual axis chart because there are also dual dates...

View 3 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

How To Plot 2 Chart Types On One Graph In VBA

Apr 14, 2014

I would like to create a chart in vba which contains 2 sets of data, both using the same x axis. The first must be a line graph, the second a staggered bar chart. This must be represented on one chart with data labels. Also, how do I change the colour of the plots?

View 5 Replies View Related

Use Excel To Plot Growth Curve?

Mar 15, 2012

I would like to use excel to plot a growth curve. I would like it to plot the points that correlate to my data without connecting them by a line. I would then like to give excel a formula and have it plot that line on the graph.

View 9 Replies View Related

Creating A Range Of Values To Plot?

Apr 8, 2012

I am importing a text file and plotting some of its contents versus time. The file provides the end time and the step interval. I know that in Matlab you can define a set of values with the start, end, and interval, but I'm having a hard time figuring out how to do this with VBA. I have toyed with fill series, but no luck there.

Specifically, the file I'm reading in (a relay event file with voltages and currents) gives the maximum cycles as 15 and the samples per cycle as 16. Therefore, for each voltage or current sample, I need the time to show as 1/16, 2/16, 3/16, ..., all the way to 15 cycles. I have tried to manually do this and record the macro, but after I put in a few x/16s, when I try to extend the formulas down the rest of the cells, instead of continuing the trend (4/16, 5/16, 6/16, etc.), it repeats what I put in first.

View 1 Replies View Related

X-Y Plot That References Indirect Range

Jun 29, 2012

$TC$2:$WX$3

is an indirect range that resides in cell B15. It is constantly changing and the expectation is that the X_Y plot would adjust accordingly. It represents the data range of the chart. The chart does not carry with it any title.

So how do I approach this without using vba? As always any input is highly valued.

View 2 Replies View Related

How To Plot Multiple Charts Using Macro

Jul 6, 2012

I would like to generate a macro which can work on by importing an excel tabulated datas and plot it into several graphs in one click and added with a filter function would be best.

Here i link one of the sample of macro for this :

[URL]

View 5 Replies View Related

VBA Plot Two Ranges In Different Colors In Same Graph

Oct 4, 2013

I have two ranges of cells containing names of chemicals, call the first one "Product" and the second one "Byproduct".

Also, there are two other ranges of cells, called "Productvalue" and "Byproductvalue". These cells contain the numerical values of products and byproducts. How can I plot both the products and byproducts in the same graph using xlBarClustered in different colors?

View 1 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)
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?

View 1 Replies View Related

Update Or Refresh Plot While VBA Running

Apr 25, 2014

I have a program which iterates on command. A plot on the spreadsheet is designed to show the progress of the iteration. However, the plot does not update while VBA is running. What is the command or technique to refresh the plot at an intermediate stage in the calculation?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved