Data Label Frequency
 

Hello,
I have a data series with many data points (100s or 1000s) in a scatter
plot. I would like to plot data points with data labels, but if I plot all
data labels it just looks like a big thick smear of a line. Is there a way
to select data label frequency plotted so that I the plot skips some of the
data?
Thanks, Pete.

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

Data Label Frequency
 

Hi,

Create another series, which will used to display a subset of the data
labels.
Create the series using a formula something like, assuming data point is in
I3. Copy down column.

=IF(MOD(ROW(),5)=0,I3,NA())

This will display every 5 points label.
Format the original series to have no data labels.
Format the second series to have no line or marker, data labels.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Pete" wrote in message
...
Hello,
I have a data series with many data points (100s or 1000s) in a scatter
plot. I would like to plot data points with data labels, but if I plot
all
data labels it just looks like a big thick smear of a line. Is there a
way
to select data label frequency plotted so that I the plot skips some of
the
data?
Thanks, Pete.

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

Data Label Frequency
 

Hello Andy,

I was afraid this was the only way. Unfortunately, I have lots of data so
although this is workable, it will be tedious. Most other
scientific/engineering data packages have a "frequency" or "skip" option so
that you are able to format the plot rather than add more data to an already
crowded sheet.

Microsoft, please add a "Frequency" option to formatting.

Thanks for the help Andy,
Pete.

"Andy Pope" wrote:

Hi,

Create another series, which will used to display a subset of the data
labels.
Create the series using a formula something like, assuming data point is in
I3. Copy down column.

=IF(MOD(ROW(),5)=0,I3,NA())

This will display every 5 points label.
Format the original series to have no data labels.
Format the second series to have no line or marker, data labels.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Pete" wrote in message
...
Hello,
I have a data series with many data points (100s or 1000s) in a scatter
plot. I would like to plot data points with data labels, but if I plot
all
data labels it just looks like a big thick smear of a line. Is there a
way
to select data label frequency plotted so that I the plot skips some of
the
data?
Thanks, Pete.

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

Data Label Frequency
 

FWIW, Excel is not a scientific/engineering package, nor is it a statistics
package. It's at heart an accounting package, and over the years they've
stuck some math and science into it. Some of us are trying to help people
use it for a broader range of topics. I'm a former research scientist and an
amateur visualization guy, and I've learned that Excel isn't too bad for
those things, if you ignore defaults and try different approaches.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Pete" wrote in message
...
Hello Andy,

I was afraid this was the only way. Unfortunately, I have lots of data so
although this is workable, it will be tedious. Most other
scientific/engineering data packages have a "frequency" or "skip" option
so
that you are able to format the plot rather than add more data to an
already
crowded sheet.

Microsoft, please add a "Frequency" option to formatting.

Thanks for the help Andy,
Pete.

"Andy Pope" wrote:

Hi,

Create another series, which will used to display a subset of the data
labels.
Create the series using a formula something like, assuming data point is
in
I3. Copy down column.

=IF(MOD(ROW(),5)=0,I3,NA())

This will display every 5 points label.
Format the original series to have no data labels.
Format the second series to have no line or marker, data labels.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Pete" wrote in message
...
Hello,
I have a data series with many data points (100s or 1000s) in a scatter
plot. I would like to plot data points with data labels, but if I plot
all
data labels it just looks like a big thick smear of a line. Is there a
way
to select data label frequency plotted so that I the plot skips some of
the
data?
Thanks, Pete.

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