I need help with modifying Excel files

Hi @DePhillips Jr., Henry A,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your sharing, let me help you with your questions:

1/ How to expand regions of a chart?

Can you confirm that when you say “expand regions of the chart,” did you mean which one of these:

• Make the whole chart bigger
• Make the plotted area bigger (the area inside the axes)
• Change the axis range (zoom into part of the data)?

In the meantime, you can follow the basic guidance in this article: Move or resize a chart - Microsoft Support

2/How to modify axes on a graph?

For Y-axis:

• Click the chart > Click the Y axis numbers (vertical axis) > Right‑click > Format Axis.
• In Axis Options, you can set Minimum / Maximum, Major / Minor units, Logarithmic scale, Display units, etc.

For X-axis:

• Click the chart > Click the X axis labels (horizontal axis) > Right‑click > Format Axis. In Axis Options, you can adjust: Axis Type (Text axis vs Date axis), Interval between tick marks/labels, Label position, etc.

3/How to give axes a name?

• Click the chart > Click the + button (Chart Elements) near the chart
• Check Axis Titles > Click each “Axis Title” box and type your labels.

For reference: Add or remove titles in a chart - Microsoft Support

I hope this helps you move forward smoothly. If you have any questions or need further assistance, please feel free to reach out again on this post so I can continue to support you.  

Thank you for your patience and understanding. Looking forward to your response.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".       

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Thanks for trying. I will go some where else.

As a novice to using Excel, these responses are NOT enough to get me started. Perhaps you can recommend an Excel manual I can purchase.

To modify Excel charts, you can follow these steps:

1. Expanding Regions of a Chart: You can adjust the data range for your chart by using defined names or directly modifying the data source. For example, you can create defined names for your data ranges, which will automatically update the chart as you add new data.
2. Modifying Axes on a Graph: To modify the axes of a chart, you can use the Excel JavaScript API. For example, to set the title of the category axis, you can use the following code:

      await Excel.run(async (context) => {
          let sheet = context.workbook.worksheets.getItem("Sample");
          let chart = sheet.charts.getItemAt(0);
          chart.axes.categoryAxis.title.text = "Your Axis Title";
          await context.sync();
      });
   

   Similarly, you can set the display unit of the value axis:

      await Excel.run(async (context) => {
          let sheet = context.workbook.worksheets.getItem("Sample");
          let chart = sheet.charts.getItemAt(0);
          chart.axes.valueAxis.displayUnit = "Your Display Unit";
          await context.sync();
      });
   

3. Naming Axes: You can name the axes of your chart using the same method as modifying them. Set the title.text property of the respective axis to the desired name.

By following these methods, you can effectively modify your Excel charts and axes as needed.