Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |