How To Change The Values Of The X Axis On Excel
04-xxx-2008,01:43 AM #one
Registered User 
how to modify the value of 10 -axis on the excel graph
can you pls aid out guys? wen i plot my excel graphs, the values of the x-axis are one,2,3,4 not their truthful values. can you pls assistance out how to modify it? thank you
im using windows xp..
Terminal edited by killa; 04-30-2008 at 01:44 AM. Reason: for clarity
02-11-2013,12:01 PM #6
Registered User
Re: how to alter the value of x -axis on the excel graph
I don't find Nautical chart/Source anywhere, and when I click on Data all of the icons are inactive.
Originally Posted past ChemistB
Click on the graph. Go to Chart>Source Information>
Put your cursor in Catagory Ten Labels box and and then highlight the cells you want to be your 10 axis.ChemistB
02-eleven-2013,01:23 PM #seven
Re: how to alter the value of x -centrality on the excel graph
That was for Excel 2000 or 2003,For 2007, 2010, When you lot click on the chart, 3 new tabs are added to your Ribbon under the topic of "Chart Tools". They are "Design", "Layout", and "Format". Under "Design" is the option to "Select Data"
ChemistB
My 2�substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Alter Prefix)
If I helped, Don't forget to add together to my reputation (click on the little star at bottom of this postal service)Forum Rules: How to use lawmaking tags, mark a thread solved, and keep yourself out of trouble
06-03-2013,01:08 PM #8
Registered User
Re: how to alter the value of ten -axis on the excel graph
I have 2 X-Y besprinkle plots that I need to compare and therefore, the x-axis (and y-axis) values need to exist the aforementioned. I need three graphs, one each of the two regions and 1 combining all of information technology together. I've included the excel file for review and if someone could tell me how to achieve this, I would greatly appreciate every bit I anticipate this becoming a frequent problem. In the file, the graphs in question can be found on the last iii tabs to the right. One tab is for Veneto, one for Lombardia, and the other for both combined. Thanks!Forgot to mention, ideally I need the x-axis value to get from 60% to 110% and the y-axis from 0% to 14% only considering my data involve numbers to the second decimal point, I'd also like to know if there is a way to change the icons used in the legend to a much smaller bullet point type of symbol. Some of my measurements are 0.02 or 0.04 or 0.08 and on the graph, these appear all lumped together at 0%. While seemingly insignificant, I demand the graph to visually differentiate from these as much as possible. Thanks!
Final edited by MiRoNYC; 06-03-2013 at 01:35 PM.
06-03-2013,01:28 PM #9
Re: how to change the value of x -centrality on the excel graph
MiRoNYC,Unfortunately you need to postal service your question in a new thread, it's against the forum rules to mail service a question in the thread of some other user. If you create your own thread, whatever advice will be tailored to your situation so y'all should include a description of what yous've done and are trying to practice. Also, if you feel that this thread is especially relevant to what you are trying to exercise, you tin can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to marker threads every bit "Solved" (Thread Tools->Marker thread as Solved)
Utilize code tags when posting your VBA code: [code] Your code here [/lawmaking]
06-03-2013,01:35 PM #10
Registered User
Re: how to change the value of x -axis on the excel graph
Done, how do I delete my post above?
06-03-2013,02:34 PM #11
Re: how to change the value of 10 -axis on the excel graph
Dont worry about it. You practice not demand to delete information technology.
Source: https://www.excelforum.com/excel-charting-and-pivots/643201-how-to-change-the-value-of-x-axis-on-the-excel-graph.html
Posted by: bartleytheds1985.blogspot.com
0 Response to "How To Change The Values Of The X Axis On Excel"
Post a Comment