How to set the series on the right in excel is displayed as the abscissa name

The line chart I want to make is based on the "composite colloidal viscosity" as the ordinate and the "placement time" as the abscissa.

2 First, select the Insert icon in turn Select "Line Chart" in "Standard Type" (as shown in the figure below) Click "Next" to appear in the next image The interface shown in the next picture Click "Next". As shown in the second image.

Click on the area circled in red and select the data of the ordinate of the line chart you want to make (don't choose the title, just select the data). Here I select the data corresponding to "Composite Colloid Your Viscosity". When you're done, click on the same icon to go back to the next ** screen.

Attention! Now you can't click "Next!" ”

Click on the red circle to the right of the "Category (X) mark" and select the abscissa data you want to set here, here I select the data corresponding to the "Place Time" (no need to select the title, just select the data). When you're done, click on the same icon to go back to the next ** screen.

Click "Next" to design each content shown in the figure below, and you can see that the abscissa is no longer 1 2 3 4 5 6, but 3 4 5 6 7 in my data table

Classification x-axis: The name and unit of the x-axis, displayed under 3 4 5 6 7.

Classification y-axis: The name and unit displayed to the left of the vertical axis data.

After setting up, click "Next" to enter the interface shown in the figure below, where "Insert as Object" is used to set the worksheet that the chart will display. Here I have renamed the worksheet, the worksheet that is being worked on is "Data", you can also set "Worksheet 1", "Worksheet 2", "Worksheet 3", so that the chart is displayed in a separate worksheet.

See, my name has changed, it's not "Worksheet 1" "Worksheet 2"."Worksheet 3"

Can you be specific? Be clear.

Preparation materials: computer, excel2016

1. Select the chart first, and then click the "Design" menu in the chart tool above.

2. In the ribbon that opens, find the "Add Chart Element" button.

4. Click on the left side of the icon and enter the vertical axis title.

6. Enter the information of the abscissa axis in the same way, and finally adjust the title of the coordinate axis to the appropriate position.

Summary. Kiss. Good morning, glad to answer for you. <>

The following is the Excel abscissa debugging process found for you.

Open a worksheet with charts in Excel, select the axis of the chart with tick values, which may be horizontal or vertical, right-click, and select the "Format Axis" option in the pop-up shortcut menu.

At this time, the "Format Axis" pane will be opened, and the "Axis Options" will be automatically opened, you can adjust the values in the "Boundary" and "Units" areas according to your needs, the minimum value represents the starting value of the scale, the maximum value represents the end value of the scale, and the main value in the unit is modified, it represents the interval of the scale.

After all the changes are made, click Close in the upper right corner of the Format Axes pane to return to the worksheet to view the modified chart effect.

Excel how to display the abscissa how to call it up.

Hello dear, I am a gold medal mentor of Yanmo Social Livelihood, and I have served 3,100 people in total, with a cumulative service time of more than 2,800 hours! I have received your question, it will take some time to answer, please wait a little bit, it will take 5 minutes to get the result, please don't end the consultation, you can also provide more effective information, so that I can better answer for you If my answer is helpful to you, please give it a thumbs up, thank you for <>

Kiss. Good morning, glad to answer for you. <>

The following is the debugging process of excel abscissa for you Open a worksheet with charts with excel, select the coordinate axis of the chart with scale values, which may be the horizontal axis or the vertical axis, and then click the right mouse button, and select the "Set Coordinate Axis Format" option in the pop-up shortcut menu. At this time, the "Set Axis Format" pane will be opened, and the "Axis Options" will be automatically opened, you can adjust the values in the "Boundary" and "Unit" areas according to your needs, the minimum value represents the starting value of the scale, the maximum value represents the end value of the scale, and the main value in the unit is just modified to indicate the interval between the engraving and gripping. After all the changes are made, click Close in the upper right corner of the Format Axes pane to return to the worksheet to view the modified chart effect.

I hope my answer is helpful to you, please give a thumbs up (comment in the lower left corner), look forward to your like, your Jane's efforts are very important to me, and your support is also the driving force for my progress. Finally, I wish you good health and a happy mood! ~<

<> big stop Bi Wang Honghua].

1. First, select the data cells in Excel**, click Insert Chart and select a chart style.

2. Then right-click on the coordinate axis position of the inserted icon, and click the "Set Coordinate Axis Format" option in the pop-up options.

3. Then in the settings window that opens, set the displayed title unit drop-down menu as you need.

4. For example, select "hundred" to add the unit title at the position of the coordinate axis.

5. If you need to add a numeric value, you can right-click on the column chart and select "Add Data Label".

6. You can add a numerical label above the column chart.

1. Let's take a look at the chart without a title, which looks unintuitive.

2. At this time, we select the chart, and then click the "Design" menu in the above chart tool 3, and find the "Add Chart Element" button in the open ribbon.

5. Click on the left side of the icon, enter the content of the ordinate axis title 7, and then enter the information of the abscissa axis, and finally adjust the axis title to the appropriate position.

The first way: just insert the text box and move it to where you need it, the steps are as follows:

1) Insert - text box (then type: meta)).

2) Right-click on the border of the text box - Format the shape (3) Line color - Wireless bar.

The second type: click on the diagram, the menu bar "layout" "axis title" horizontal and vertical headings The third type:

1. First, copy the data to Excel, select the data, generate a chart, and set it up accordingly in the generation wizard.

2. Then set the parameters in several parts of the chart until you are satisfied.

3. Finally, copy the chart to word.

1.The name of the year should be taken as the abscissa, and the transportation business, warehousing business, and value-added business should be used as the legend.

Click on Chart Tools - Design - Select Data and proceed to the Legend Item (Series) - Horizontal (Classification) axis tab.

2.Data series, the series name and series value.

3.Horizontal (classified) axis label –

4.Click to set the axis format: type of x-axis line (solid line) - color - width setting.

5.Text alignment – vertical.

6.Tick mark marks – inside.

If the ordinate data for the selected point exists in the source data, then this effect can be achieved by adding a secondary data series. The following uses Excel 2010 as an example to demonstrate this process:

1. The original chart is shown in the figure below, assuming that the points (15,8) need to be marked now2, and the following auxiliary data series is made.

3. Add auxiliary data series (click ** to view the dynamic demo) 4. The final effect is as follows.

It shouldn't be, why, because the above data is generated by the data in **, unless there is this point in **, it can be displayed, if there is no such point in **, how can it be displayed, the data cannot be displayed, and the data is not continuous, Bunsen is not a curve!

If this data is not in **, then at present, it should not be possible.

1. Open Excel** on the computer, and list the abscissa you want to change.

2. Then select the abscissa, right-click and select the data.

3. After clicking Select Data, click on the Horizontal Axis tab.

4. After clicking, check the name of the abscissa just listed, and then click OK.

5. After clicking OK, the abscissa will be changed.

The chart in Excel has been renamed the abscissa name.

The steps of the method are as follows:

1. Open the Excel** you need to operate, right-click on the icon, and click "Select Data".

2. Click the "" button under the axis label.

3. Click the Select Axis Label Data Area back area area selection button.

4. Select the data area that needs to be used as the axis name, and return to the selection data source setting interface.

5. Click the OK button in the lower right corner.

6. Return to excel**, and you can find that the abscissa name has been successfully changed.

1. Right-click in the chart area and click Select Data.

2. Click the button of the horizontal classification axis.

3. Select the abscissa data area.

4. Done.

07 version of Excel. Right-click the icon, select "Data Source", and modify the "Horizontal Axis Label" on the right in the pop-up dialog box.

1. Right-click in the chart area and click Select Data.

2. Click the button of the horizontal classification axis.

3. Select the abscissa data area.

4. Done. Excel is an electronic program in the Microsoft Office System. You can use Excel to create and format workbooks (electronic collections) so you can analyze data and make more informed business decisions. In particular, you can use Excel to track data, generate data analysis models, write formulas to perform calculations on your data, pivot your data in a variety of ways, and display it in a variety of professional-looking charts.

In short: Excel is an office software that makes it easier to work with data.

To modify the abscissa name of the chart in Excel, you first need to select the chart area you want to modify, right-click, and then select the [Select Data] option. Then, a [Select Data] dialog box will pop up, click the button option under [Horizontal Axis Label], a [Axis Label Area] setting dialog box will pop up, enter what you want to change, click the [OK] option, so that the abscissa name will be modified.