Why XY CHART?herclau
Do You would like to get range A2:B6 -data to look like Your chart?
... why those 'steps'? ... I skipped those.
... why XYChart? ... anyway sample of it.
... also other chart sample
All depends from real needs.
Please explain the WHY and WHAT with more details.!!!!!herclau
Many things are possible to do even many ways...
but if You cannot write WHY?
and later WHAT?
... then some cases have again challenges.
This example is the excel file shown in # 1.herclau
Why & What of 'Automate the process of creating histograms with XY CHART!'
Your needed chart sample result looks same as mine result (right one) .
Even I know, that You would like to do something ... but You should explain 'what' ... with needed sample.
Is this possible or not? And if possible: how to do it?herclau
No new details for me, sorry.
There are same ten values to show in a chart .. same way.
Isn't it ready? ... or what would be missing?
Even 'my files' XYchart shows same
( without 'right side line' or any specific methodology or any formulas ).
How add a 'best fit' line?Updated file
... used range (A2:B7) to get same histogram without any formulas
View attachment 62167
herclau
How to know, what would a 'best fit' line mean?
PS. if range A2:A7 values would be eg -105, -75, -35, 15, 75,145 then there needs help column.
What would be Your a 'best fit' -line logic: Histogram With Normal Curve Overlay, It's what I'm looking for. But I would like to achieve with simple solution proposed aboveherclau
As I wrote: How to know, what would a 'best fit' line mean?
1st values are -105 & 3 ... and ... that's the 'best fit'-value is -105 & 0 ... hmm?
2nd values are -60 & 1 ... and ... that's the 'best fit'-value is -60 & 1,75 ... hmm?
What would be Your a 'best fit' -line logic?
Genial!!!This is an attempt to achieve a plot of the type you describe using named (array) formulae rather than helper cells.