Excel help

Question

I am creating a bell curve and i want one portion of it shaded, right now that portion is just a line but when i press 'solid fill' in the format data series tab nothing happens/nothing is shaded. can you explain how to shade a portion of a curve?

Answer 1

In Excel’s built‑curve setup, the curve is an XY (Scatter) line series, so Solid fill affects the area of a column/area series, not a line. To shade only part of the curve, the curve segment must be turned into an area (or separate series) and then filled. The context only covers creating the bell curve line and histogram, not partial shading of the curve, so only the supported steps can be described:

1. Create the bell curve as an XY (Scatter) chart with smoothed lines, following the documented steps:
   • Generate normally distributed data using Data Analysis → Random Number Generation with Distribution = Normal, Mean and Standard Deviation set from worksheet cells, and an Output Range (for example D2). This produces the random values.
   • Build a histogram from those random values using Data Analysis → Histogram with the Input Range and Bin Range, and output the results.
   • Select the data range (for example E2:H10) and insert an XY (Scatter) chart with “Scatter with data points connected by smoothed lines without markers.”
2. The resulting chart is a line representation of the distribution. Excel’s built‑in options in this documented flow do not include a step to shade only a portion of that line; the Format Data Series → Solid fill option does not apply to the line itself in this configuration.

Because the provided instructions stop at creating the smoothed line bell curve and do not describe converting part of the curve to an area or adding a separate filled series, there is no supported, documented procedure in this context for shading only a portion of the curve.

---

References:

• How to Create a Bell Curve Chart

Answer 2

I am creating a bell curve and i want one portion of it shaded...

I see that you accepted an a.i. generated response...