Different version of Excel/ HP Chromebook x360

Sarah Ramirez 0 Reputation points
2026-10-27T12:08:25.4133333+00:00

I have a HP Chromebook x360 and have to do an online assignment for school. When I have looked up tutorials on how to do things, such as making a histogram using data for both the y-axis and x-axis, it shows me tutorials for another version. I do not have the options they show on these tutorials. I cannot seem to find a tutorial for this version that my computer uses. Can anyone provide guidance in how to use this version of Excel, especially when making charts, like a histogram?

I know how to begin the histogram, I have the data on the x-axis, I do not know how to add the data I need for the y-axis.

The Title of Bin is the x-axis, I need Frequency as the y-axis. Screenshot of the options Excel gives me for the y-axis is attached.

Screenshot 2026-10-27 6.06.12 AM.png

Microsoft 365 and Office | Excel | For education | Android
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-10-27T12:09:03.4866667+00:00

    Because your worksheet already contains Bin and Frequency values, select both columns and create a 2-D column chart rather than Excel’s automatic Histogram chart.

    Create the chart

    Arrange the worksheet like this, with one row per bin:

    Bin Frequency
    0–9 3
    10–19 7
    20–29 5

    Then:

    1. Select the complete two-column range, including the Bin and Frequency headings.
    2. Select Insert → Charts → Column → 2-D Clustered Column.
    3. Excel should use:
      • Bin as the horizontal (x) axis.
      • Frequency as the vertical (y) values.
      • Frequency as the series name.

    A column chart places categories on the horizontal axis and their values on the vertical axis, which matches an already-calculated frequency table.^1^

    Do not try to enter Frequency as an axis-formatting option. The y-axis gets its numbers from the Frequency data series, not from the axis settings.

    Correct the chart you already made

    Since you already started the chart:

    1. Select or right-click the chart.
    2. Choose Select Data.
    3. Under Data → Source, change the range so it includes both the Bin and Frequency columns.
    4. If Frequency is still absent, use Data → Setup → Add Field, select the Frequency cells, and apply the change.^2^
    5. Select the chart, open the Chart or Chart Design options, and change its type to 2-D Clustered Column if it is currently set to Histogram.

    If your teacher specifically requires an XY (Scatter) chart, place numeric x-values in the first column and frequencies in the second. Excel for the web expects scatter-chart x and y values in that order.^3^

    Why the Histogram option behaves differently

    Excel’s built-in Histogram chart normally takes the raw observations and groups them into bins itself. Excel then counts how many observations fall into each bin.^4^ If Frequency has already been calculated, a regular column chart is the appropriate way to plot those existing totals.

    On a Chromebook, Microsoft supports using the browser-based Microsoft 365 apps; the Windows or Mac desktop editions cannot be installed, and the Android Office apps are not currently supported on Chromebook.^5^ Therefore, tutorials showing desktop-only menus may not match the interface on the Chromebook.

    References

    1. Present your data in a column chart | Microsoft Support
    2. [Web](https://support.microsoft.com/excel/get-started/create-a-chart-from-start-to-finish)
    3. [Web](https://support.microsoft.com/excel/select-data-for-a-chart)
    4. Create a histogram
    5. How to access Microsoft 365 on a Chromebook | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Aetherin 3,680 Reputation points Independent Advisor
    2026-10-27T12:46:49.4233333+00:00

    Hi @Sarah Ramirez,

    Based on the screenshot, you are using Excel for the web on a Chromebook, so the interface and available chart options may look different from tutorials created for the Excel desktop application.

    The issue is not that the Chromebook cannot add values to the Y-axis. In the screenshot, only the Title of Bin range appears to have been selected when the Histogram was created. Excel is therefore treating those numbers as the source observations, automatically grouping them into bins, and counting each value once. This explains why each bar has a height of 1 and why the Y-axis ranges only from 0 to 1.2.

    Excel’s built-in Histogram chart is normally created from the source observations and calculates the bins and frequencies automatically. In this worksheet, however, the bin titles and frequencies have already been calculated in the Title of Bin and Frequency columns.

    For this assignment, the better approach is to create a Clustered Column chart from both columns:

    • Delete the current chart.
    • Select the Title of Bin and Frequency columns, including their headings. Based on the screenshot, the range appears to be F27:G38.
    • Go to Insert > Column or Bar Chart > Clustered Column.
    • If the option is available, reduce the series Gap Width to 0% or close to 0% so the columns resemble a histogram.
    • Add Title of Bin as the horizontal axis title and Frequency as the vertical axis title.

    This will use the Title of Bin values as the category labels on the X-axis and the Frequency values as the column heights on the Y-axis. Excel supports arranging category labels and their corresponding values in adjacent columns when creating a column chart.

    You can refer to the following helpful guidance:

    I hope these resources provide some useful approaches you can try. If you have any updates or further questions, please feel free to reply, and I'll be happy to assist you further.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.