Thread: Excel should let you graph every n-th data point in a column

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

It's on the Charting FAQ:

http://pubs.logicalexpressions.com/P...?ID=209#jon024

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"warrenrob50" <warrenrob50@discussions.microsoft.com> wrote in message
news:AA93EBB3-4E0C-4B94-8F04-99100B590765@microsoft.com...
>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

For a few different approaches see
Select Markers
http://www.tushar-mehta.com/excel/ne...ers/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"warrenrob50" wrote:

> 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

Tushar uses smoke, while I prefer mirrors.

- Jon


"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
news:83BEEDEF-39D1-416F-8E0E-DF6BCE4CF9BD@microsoft.com...
> For a few different approaches see
> Select Markers
> http://www.tushar-mehta.com/excel/ne...ers/index.html
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Custom business solutions leveraging a multi-disciplinary approach
>
>
> "warrenrob50" wrote:
>
>> 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