When I hover over the point it will say Series 1 Point "48" and then it will give the position of the point as (33,420). For example, I may be trying to plot the point (48,420)īut it will show up at point 33 on the X axis because it is the 33rd item in the column. STEP 2: Got to Chart Design > Add Chart Element >Axis Titles > Primary Horizontal STEP 3: Type Age of House. You can add colors, data labels, axis titles, etc. When I look at my graph however, the points are in the wrong spot. Formatting a Bubble Chart is vital to enhance the visual appearance of the chart. Just to clarify, when I enter the data under select data the correct values can be seen in the "Horizontal (Category) Axis Label" column. Instead of a number for example? I can see why it would plot the values in the order they appear in the column if it thought they were text strings. I am copying the information over from pivot tables in microsoft access, could that be causing a problem in the format of the data causing excel to misinterpret it as a text string I copy them? If I type out a smaller series by hand it works with 2 columns. I think perhaps the problem is that the numbers are not necessarily transferring as "numbers" when In Excel 2003 you could define the range of x values, y values and labels ref. I was unsuccessful in using 'Define Data Source' as I was only able to plot information one row at a time. I want to create a scatter chart and define these 3 values. I was merely explaining what happens with the line plot to give more information about what was going on with my excel. I have a table with 3 columns of data (x value, y value, label).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |