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

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

- Hide data point in graph when reference cell has #NUM!
- Labelling data points in Excel graph(Plz help)
- Excel should let you graph every n-th data point in a column
- Excel should let you graph every n-th data point in a column
- How do I label data points in a scatter graph
- Individual labels to data point in Excel charts
- Excel Chart - Too many data points in Series?
- Labels on data points in chart
- Renaming Data Points in 3D Chart
- Data "Point" in graph not matching table
- How can I add a footnote or comment to a data point in a chart?
- Show 3 sets of data per data point in a scatter plot
- How do I add a comment to a data point in a chart?
- Moving data points in chart
- Formula to match a data point in 2 wrkshts
- Creating Custom Data Points in Charts
- Conditional format data point in scatter plot
- How to use Search, find last data point in column then select from that to ActiveCell
- Click data point in chart and delete
- Data "Point" in graph not matching table
- Height (in points) of data point in chart above x-axis
- How do I set different error bars per data point in a series
- Add only vertical error bars to a single data point in a series.
- Alternate labels for data points in graph

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

Thanks

Indrajit.

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

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

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.

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

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!

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.

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!

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

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.

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?

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?

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

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,

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

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

deleting this point either from the series or from the worksheet it's

being referenced from?

thanks.

smokii

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

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.

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

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!