Prev: Pivot table creates stacked column
Next: How to do a pivot table with 2 different results
From: MarshaD on 4 Mar 2010 17:10
Simple data set yet when I create a bar chart the bars do not match the
actual values in the cells. For some reason, Excel produces a bar that is
less than the actual value. Further, the same values in a cell produce
different bar heights and although the data labels are the right number, the
value is always listed as something less. How/why is it creating bars of a
different value from the data point?
From: Jon Peltier on 5 Mar 2010 07:59
Is it a 2D bar chart? If not, change it.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/4/2010 5:10 PM, MarshaD wrote:
> Simple data set yet when I create a bar chart the bars do not match the
> actual values in the cells. For some reason, Excel produces a bar that is
> less than the actual value. Further, the same values in a cell produce
> different bar heights and although the data labels are the right number, the
> value is always listed as something less. How/why is it creating bars of a
> different value from the data point?
From: Ms-Exl-Learner on 21 Mar 2010 06:11
a

"MarshaD" <MarshaD(a)discussions.microsoft.com> wrote in message
news:1A959DED-1AA8-4253-92B1-3B7386D2102B(a)microsoft.com...
> Simple data set yet when I create a bar chart the bars do not match the
> actual values in the cells. For some reason, Excel produces a bar that is
> less than the actual value. Further, the same values in a cell produce
> different bar heights and although the data labels are the right number,
> the
> value is always listed as something less. How/why is it creating bars of
> a
> different value from the data point?


 | 
Pages: 1
Prev: Pivot table creates stacked column
Next: How to do a pivot table with 2 different results