Data Values

  • Thread starter Thread starter MS
  • Start date Start date
M

MS

Can anyone tell me how to create my data values to show
the total of the data points instead of each individual
data point?
 
MS said:
Can anyone tell me how to create my data values to show
the total of the data points instead of each individual
data point?
Click to expand...

Are you attempting to label each point of the chart with a total? If so,
you can create a helper cell (or cells) with the total that you want
displayed on the chart. Then use the XY chart labeler from www.appspro.com
to label your data points with the cells you just created.

Dave
dvt at psu dot edu
 
I will look into this however I have another graph that is
totally a stack of data points so I know that it is a
matter of programming the "value" box in the data label
section I just can't seem to get to where that is at.
-----Original Message-----


Are you attempting to label each point of the chart with a total? If so,
you can create a helper cell (or cells) with the total that you want
displayed on the chart. Then use the XY chart labeler
Click to expand...
from www.appspro.com
 
ms said:
I will look into this however I have another graph that is
totally a stack of data points so I know that it is a
matter of programming the "value" box in the data label
section I just can't seem to get to where that is at.
Click to expand...

What kind of chart is it? Pie, bar, line, XY, ...

Dave
dvt at psu dot edu
 
-----Original Message-----


What kind of chart is it? Pie, bar, line, XY, ...

Dave
dvt at psu dot edu


It is a combination chart. Bar/line - I have each week
Click to expand...
stacked on top of each other and then I have the previous
quarter as a line. I want the stacked weeks total above
the stack and do not want the quarter number. Currently
my graph displays the numbers for each week instead of the
total of the weeks.
 
ms said:
It is a combination chart. Bar/line - I have each week
stacked on top of each other and then I have the previous
quarter as a line. I want the stacked weeks total above
the stack and do not want the quarter number. Currently
my graph displays the numbers for each week instead of the
total of the weeks.
Click to expand...

How about a dummy series? Plot the total number as a set of bars on your
graph. Format the bars to be invisible. Display the data values for that
series.

I'll supply more detailed info if you wish. Dummy series are very well
described by Jon Peltier at
http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html.

Dave
dvt at psu dot edu
 
Back
Top