ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data "Point" in graph not matching table (https://www.excelbanter.com/charts-charting-excel/60407-data-point-graph-not-matching-table.html)

Brian

Data "Point" in graph not matching table
 
When you create a linegraph in excel and mouse over a bar, it gives a pop-up
with summary information - Series, Point, and value. What exactly does Point
represent and how do I get it to match the "Point" in my table that
corresponds to the x axis

Jon Peltier

Data "Point" in graph not matching table
 
Does the X axis use the labels from your table, or just the counting numbers
1, 2, 3, etc.? If not, use Source Data from the Chart menu, Series tab, to
add X Values (i.e., Category Labels) to the series.

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


"Brian" wrote in message
...
When you create a linegraph in excel and mouse over a bar, it gives a
pop-up
with summary information - Series, Point, and value. What exactly does
Point
represent and how do I get it to match the "Point" in my table that
corresponds to the x axis





All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com