Free Microsoft Excel 2013 Quick Reference

skip data points in graph

If I want to plot a x-y graph in Excel with 100 data points, is it possible
to have Excel automatically pick every 10th point (for example). I know I
can manually choose every 10th point, but can Excel do it just by clicking a
box or something?

Ayesha


Hello,

This is my first time posting in a forum so please forgive any ignorance.

I have a month-to-month cycle time graph that points to a range of cells. This is a rolling graph so now that it is July the graph shows data points from JAN-JUN only. Obviously when the range of cells referenced are blank then the graph for that month is blank. If the reference cells indicate #NUM! (because they point to other cells with formulas) then the graph shows those as a data point at the bottom of the axis line. Is there way for the graph not show the data point when cell indicates #NUM! but then show it when a number does populate the reference cell?

Thank You

Hey I am new member. I have problem in labelling data points in a scatterred graph in excel. I have three columns-A,B and C. I want to do a scatter plot between Column A and B. But the label to be dispalyed for those points in the graph I would like to be the value of Column C. I have large dataset, so it is really hard for me to label it manually for each data point. So I would like to know an automated procedure where I can label all the dat points at once. Currenlty the excel allows to label for either values of X axis or Y axis. So I would highly obliged if any one can help me out.

Thanks
Indrajit.

I just want to make the suggestion that you should be able to graph every
n-th data point in a set of data on a scatter plot. I have a set of data
with thousands of points, and I have a model prediction to match. The best
way to differentiate between a set of data and model prediction and
experimental data is to make the expermental data points on the graph and
make the model predictions a solid line. If you have many expermental data
points on a graph, the data looks like a solid line no matter what you do to
it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I just want to make the suggestion that you should be able to graph every
n-th data point in a set of data on a scatter plot. I have a set of data
with thousands of points, and I have a model prediction to match. The best
way to differentiate between a set of data and model prediction and
experimental data is to make the expermental data points on the graph and
make the model predictions a solid line. If you have many expermental data
points on a graph, the data looks like a solid line no matter what you do to
it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Hello, I am trying to label a data point in a scatter plot but it
keeps returning the x value. I'd like to have the store # instead.
Basically I have Store #, Acceptance % and $ Value Eligible. Right
now I have Acceptance % as my x-value and $ Value Eligible as my y-
value. I'd like the plot point to return the store # assoicated with
the x and y value.

Once I had an add-in that made it possible to add indivual labels (names) to
each data point in an Excel graph.
Somehow that add-in has disappeared, probably due to some upgrades we have
been through.
Any help is appreciated.

Thanks in advance

Sverre

I am working on a master data sheet for my 25 sales people and tracking their
progress every month. Other than the master worksheet, I also have 25 other
worksheets so I can visually graph each employees' data. 1 graph per sheet
(tab). As I go through the Create Chart wizard, I have 12 pieces of data in
12 different non-adjacent cells. Excel will only let me select 11 cells
located on the Master Sheet. Once I select the December data, my PC *dings*
and the Source Data - Values disappears back to 0.

Surely Excel 2003 11.8231.8221 SP3 will let me graph more than 11 data
points in a series? I created a new blank worksheet, and was only able to
select 18 non-adjacent cells for a data series. Am I doing something wrong?
Thanks for any help!

Is there a way to associate labels with data points in a series, and then
have the data points appear on a chart?

I don't want to directly apply the labels to the chart, but instead, I'd
like to be able to maintain the data over a period of time, and add data
points to the series. Each point would have a data label that would remain
associated with the point, and would appear any time the graph is updated.

Thanks.

Hello there. My question is this. I have set up a chart to pull data from a specific range of cells. The chart itself is fine and performs as it should. It is a 3D vertical bar chart. What I want to be able to do is place the name of each month, under each bar that represents that month. The data points in the series are being pulled from cells that are totals of each month, which is why I want to be able to place the name of the month below each vertical bar in the chart. How can I do this? I have played around with it, and have yet to have success in figuring it out by playing with it or by using the help.

Thank you in advance for any help anyone can give me. If you need more information, or need to see an example of the chart please let me know.

Thanks!

When you create a linegraph in excel and mouse over a bar, it gives a pop-up
with summary information - Series, Point, and value. What exactly does Point
represent and how do I get it to match the "Point" in my table that
corresponds to the x axis

Is it possible to create one's own text for a specific data point in a line
chart? (e.g. a word or two that is not in the data table) I can add a note
below the chart in a worksheet, but would like something that would stay with
the chart itself.

I would like to be able to plot the pieces of info for each data point in a
scatter plot and have all the information appear when the mouse hovers above
each point, i.e.: Name of School, percentage of test takers, percentage
passed. Is this possible?

I am needing to add a comment to a specific data point in a chart. For
instance, now when I scroll over a data point the source, series, and value
pop up. I need to change the pop up box to explain the reason for a specific
value. Any suggestions?

how do you click and drag a data point in an excel chart?

I need to match a data point in a new report with the previous report and then pull in a note for that matching data point.

Each month I get a report have look at the data then make a note:
Column A:work number Column D:note made by me

The data changes some of the data in A: drops off which then would make note in column D: unimportant for the current report.

I played around with various versions of:
=if(A1””,A1,””) - this was no where near complex enough to grab data from another worksheet with data points that drop off the list.

then tried this one:
=IF(('May 2012 Report'!A3:A226='June 2012 Report'!A3),'May 2012 Report'!D3: D226"",'May 2012 Report'!$D$2:$D$225) (put space between : and D got a grin)

This one gives me a True/False statement in the first to cells then it keeps referring to empty cells.

Does not account for the change in my data in Column A: so records drop everything in D: even if A: in worksheet 1 does not correspond with data in worksheet 2.

Any suggestions to fix this

Can anyone tell me how to create a custom data point in a chart? My version of excel only allows me to use rectangles/triangles/circles/etc...

I was wondering if it would be possible to create my own shape, such as a "Plus sign" to incorporate in my charts.

If anyone can help on this subject, please do

Thanks in advance,

I've been trying for some time to write some code to conditionally format data points in a scatter plot.

The following is an extract which formats the data point style for a range of data series, not very tidy I know, but it works. I wanted to control the data point style and size of series 1-29, 29-58 etc. I know hard coding is never a good idea, but it was the best I could do.

Data labels are switched off because there are too many and the chart was crowded, however I do want the data labels to show if the sum of x-co-ord muliplied by y co-ord is greater than a stated figure

x vals are decimals between 1 and 5
y vals are decimals between 1 and 5

I want all data points where x times y >20 to have the data labels switched on.

Any suggestions would be great

Extract of existing code as follows, remainder just repeats for the for the next x series and applies a different data point style

Thanks

Private Sub Chart_Activate()
Application.ScreenUpdating = False

Dim Answer As String
Dim MyNote As String

'Place your text here
MyNote = "Do you want to update the chart?"

'Display MessageBox
Answer = MsgBox(MyNote, vbQuestion + vbYesNo, "Chart Update")

If Answer = vbNo Then
'Code for No button Press
'MsgBox "You pressed NO!"
Else
'Code for Yes button Press
'Regulatory

Dim i As Integer
total = 0

For i = 1 To 29

ActiveChart.SeriesCollection(i).Select
Selection.MarkerStyle = 3
Selection.MarkerSize = 6
MarkerBackgroundColorIndex = 3

ActiveChart.SeriesCollection(i).ApplyDataLabels
ActiveChart.SeriesCollection(i).DataLabels.Select
Selection.ShowSeriesName = False
Selection.ShowValue = False

Next i

How to find last data point in Column Then select from ActiveCell to last data point using a range method?

Now I know that I could have probably found the answer to that question by searching the forums, which I did.

The problem is that the search feature removes half of my words because they are too common. The result of this seems to be that my question loses its meaning and I get hundreds of results. Any tips on how to use the search here would be appreciated.

Last questions. I keep having to manually subscribe to these posts, anyway to just make it automatic? Anyway to set it such that it emails everytime there is a response and not just for the first response?

The answers to these questions would be very useful then I can contribute and do more research on my own.

Thx

does anyone hava a routine for clicking a data point in a chart and
deleting this point either from the series or from the worksheet it's
being referenced from?

thanks.

smokii

When you create a linegraph in excel and mouse over a bar, it gives a pop-up
with summary information - Series, Point, and value. What exactly does Point
represent and how do I get it to match the "Point" in my table that
corresponds to the x axis

Hi,

Is it possible using VBA to determine the height of a given data point in a
Chart worksheet in Excel above the x-axis in terms of points? I can use the
InsideHeight property in VBA to get the height of the plot area in points,
but I am really interested in determining the number of points above the
x-axis a data point sits.

Thank you in advance for any assistance with this matter.

Prior versions of Excel allowed different error bars per data point. I am
now using Excel 2003 and apparently error bars can only be set for the entire
series. Since my data points in a series are really averages from other
series I want to include their error bars.

Hi,

I need to add only vertical error bars to a single data point in a series. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point.

How can I add only vertical error bars to a single data point in a series in Excel 2007?

Thanks,

Chris

Hi all, long-time forum-lurker, but new member and first-time poster.

I tried searching the forum for this problem, but I wasn't able to find it. If I missed it somehow, please let me know. I am using Excel 2000 and attempting to create a graph where the data labels are different than what they're next to. For instance, say I have the following data:January - 50 unitsFebruary - 75 unitsMarch - 100 unitsI have a graph set up with that data. However, next to each point, instead of displaying 50, 75, or 100, I would like another piece of data to be displayed instead, for instance:for Jan, show "$600"for Feb, show "$900"for Mar, show "$800"Theoretically, I could just use a text box, but I'd like to be able to update the "alternate" data labels dynamically by having them linked to another set of cells on the data worksheet. (So, by changing the cells on the data worksheet, I can update the alternate labels)

Does anyone know if this problem is solvable in Excel? Thanks so much!