bars on chart do not match data points

M

MarshaD

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Average bar charts with individual data points 2
Creating a Chart on form from selected data in query. 0
Bar Chart with Data Elements 1
Overlay line graph points on bar graph 1
error bars on bar chart in Excel 2007 1
formatting DATA bars 1
Cannot Add Error Bars for individual data points! 1

Top