![]() ![]() Is it is so that exact date value can't be plotted on the x-axis. Depending on which data is used, the scaling options are limited compared to the scaling options of the Scatter chart's x (value) axis. ![]() The x-axis of a Line chart can be either a category or a time axis, both of which can display non-numeric data. To display this numeric data with greater flexibility, you can change the scaling options on this axis. This means that only numeric data is displayed on this axis. The x-axis of a Scatter chart can only be a value axis. Scatter charts and Line charts also differ in the way they use axis types and scaling: I believe I tripped over the answer to your problem: in a scatter chart the X axis can only have numeric valuesīut i went through an MS Office link for creating XY (Scatter) and Line charts. ![]() Try on Layout tab / Labels group / Data labels drop down / More Data label options: In Label Options option / Label Contains: X value, Label Position Right I found this tipe, but it doesn't work in my 2007 installation, the specified option is not there. Chart type /sccater chart, #3 in the list o fchoices This chart shows labels similar to what you want:Ĭhart addition of Axis Titles and Data Labels:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |