How to make a chart with the dater in the middle and expanding left and right.

[Shinas]

I am trying to make a chart that expand from the center to right and left. The idea is, the data would go into the center pole and if the number increases then a bar would aromatically expand out to the left or right. I have a sample sheet to help clarify this.

Let me know if this is possible please.

[KOKOSEK]

I am correctly understand.
If Y values increase, X-Axis should expand from -X to X.

[Shinas]

I am not sure I understand your question. But if the vertical is Y and horizontal is X. Then if 5 ones comes in then X would have a bar going from 1 going to the right and stop at 5.
I hope this make it clearer.

[KOKOSEK]

Maybe something like:

Please Login or Register  to view this content.

and connect it into Worksheet_Change with range of Y values.

Increase Y value in yellow cells on attached file and check how Xaxis is expanded or shrink.

[Shinas]

KOKOSEK I have no idea what you gave me or how to put this thing to work. But I did learned something. I have to think this thing through a little more. So let me do that and get back to you.

[KOKOSEK]

Bar expand in both sides now, depends of vertical value.
Analyse ranges and vba code.


p.s. server works very slow today? Or it is only my issue.

[Shinas]

Hear is a much better idea of what I am doing. I have attach a file the same name.

[KOKOSEK]

Sorry I do not get it. Maybe somebody else can help.

[MrShorty]

So you are looking for a column chart (histogram) that shows how often each number (1-50) shows up in the MAX.xlsx workbook? You are using the COUNT() function to count the frequencies (a FREQUENCY() or COUNTIFS() function or even a pivot table might be easier in the long run for the counting step). At this point, it seems like it should be as easy as:
1) Select A4:AX5
2) Insert a column chart that uses row 4 as the horizontal category x axis values and row 5 as the vertical axis y values. You may need to use the Select Data Dialog after chart creation if Excel's default choices do not reflect this.
3) Format any chart elements as desired. For example, it sounds like you want the vertical axis to cross at the number 15 (category 15), so format the horizontal axis and set the "vertical axis crosses at" property to by category 15.

Did I understand correctly what you are trying to do?

[Shinas]

Yes you seem to have a pretty good idea of what I am doing. I notice you mentioned the FREQUENCY(). I do not know how to use that function and maybe that would work much better.

But now I am confuse and don't know what to do. Now the chart do not have to be left and right, it could top and bottom, if that's easier.

[MrShorty]

Help file for the FREQUENCY() function: https://support.microsoft.com/en-us/...7-fd9ea898fdb9 I don't know that it works "better" -- it really depends on what is going on in MAX.xlsx and other parts of how you intend to obtain these counts. Your OP is asking about the chart creation, so I think we are assuming that you know how to do the counting part of the overall task. We can talk about the counting step, if you want, but you have not shared anything about how you intend to do the counting step.

Column chart (left right) or bar chart (up down) doesn't really matter. They are effectively the same difficulty. It's just a matter of which you select when you create the chart.

Without knowing exactly what you are trying to do, I'm not sure what to recommend. The kind of chart you are describing seems quite similar to a histogram. Perhaps this short tutorial about building a histogram using the FREQUENCY() function and a column chart will help: https://exceljet.net/formula/histogram-with-frequency

[Shinas]

The counting part I know how to do that I just need to chart it now.

[MrShorty]

So we can focus on the chart, then. If you start with your file in post #7 and add a column chart as I outline in post #9, do you get something that make sense? What do you like about it? What do you wish it showed differently?

[Shinas]

I was looking on how to create chart in excel and I think I might be able to figure it out. I will try this and get back to you.