Change y axis from value to text

[dodde]

Hello

I try to make a chart for my montage people, i want to have Project name in y axis and week in x axis

But i can not understand how to put text in Y axis

Is there a simple way to do that

I want to see how many people i need in every week in future on different project

i have 10 rows with project

[MrShorty]

Not enough information to provide many specifics, nor to understand exactly what a "simple" solution would entail.

The only chart type that natively supports a vertical category axis is a bar chart. All other Excel chart types will have a numeric vertical axis. Can you create your desired chart as a bar chart?

If a bar chart is not what you have in mind, I am aware of two other strategies for creating a vertical category axis. There's this one: https://peltiertech.com/Excel/Charts...egoryAxis.html which is basically a scatter chart with a labeled dummy series for placing the text on the vertical axis. At the end of the tutorial, he links to a dot plot tutorial that uses a bar + scatter combination chart to do something similar.

I expect that one of those approaches will help you get the chart effect you want.

[dodde]

Hello

Yes i will try this options, Thank you