Q&A for How to Create a Graph in Excel

Return to Full Article

Search
Add New Question
  • Question
    How do I change the horizontal axis to a vertical axis in Excel?
    Community Answer
    Click "Edit" and then press "Move." If this doesn't work, double click the axis and use the dots to move it.
  • Question
    How do I print a graph only in Excel?
    Community Answer
    Type control p on your laptop or go to print on the page font of your screen?
  • Question
    How do I label a Series?
    Jayna Akanova
    Community Answer
    Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.
  • Question
    How to rename data series?
    Jayna Akanova
    Community Answer
    Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.
  • Question
    How can I change the range of numbers in the vertical axis?
    Jayna Akanova
    Community Answer
    In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Vertical (Value) Axis.
  • Question
    How can I add another vertical axis in a graph?
    Deborah Archary
    Community Answer
    Assuming you already know how to make a basic bar graph from a workbook? If not, check out Wikihow's article "Create a Graph in Excel." Keep in mind, Column A is used for your horizontal axis information. B1, C1, D1 etc. can be used as headings for each vertical axis. Input information from cell 2 onwards in each column. Just make sure any information you input into these columns correlate cell by cell with your column A horizontal axis information. The information inputted in these columns i.e. B, C, D, E, etc. will be converted into a bar in your bar graph when you select all your information, click "insert", then "chart" and choose bar graph.
  • Question
    How do I change a data series?
    Tina X
    Community Answer
    To change a data series, you would select a range of your spreadsheet appropriate for the data.
  • Question
    How do I change the color on my bar graph?
    Community Answer
    Click on the chart and go to chart design. You will get some options such as white to black. To change the color of bars, simply click on a bar. All bars will automaticly get selected. Go to format and change the color.
Ask a Question

      Return to Full Article