**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi, I wish to create a chart which row a, column a is say a value of 5, row b column a is a value of 5, but row c column a is a value of 6 (incrementing every 2 cells)

Solved by E. L. in 4 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
29/05/2018 - 10:37

Hi

Excelchat Expert
29/05/2018 - 10:37

Hi there!

User
29/05/2018 - 10:37

Thank you for the help

Excelchat Expert
29/05/2018 - 10:37

I can automate that for you

Excelchat Expert
29/05/2018 - 10:37

I will create the same in column B so you can see

User
29/05/2018 - 10:37

perfect

Excelchat Expert
29/05/2018 - 10:38

you would only have to enter the first number in cell B1

User
29/05/2018 - 10:38

exactly

Excelchat Expert
29/05/2018 - 10:39

Does that give what you need?

User
29/05/2018 - 10:39

yep

Excelchat Expert
29/05/2018 - 10:39

Awesome!

Excelchat Expert
29/05/2018 - 10:39

Please don't hesitate to ping us back with a new session if you need more assistance.

User
29/05/2018 - 10:39

so how did u do that

User
29/05/2018 - 10:39

lol

Excelchat Expert
29/05/2018 - 10:39

Oh can you see the formulas in there?

User
29/05/2018 - 10:40

ohhh

User
29/05/2018 - 10:40

smart i see what you did

Excelchat Expert
29/05/2018 - 10:40

The first row just = the cell above

Excelchat Expert
29/05/2018 - 10:40

then the second cell adds 1

Excelchat Expert
29/05/2018 - 10:40

and this repeats!

Excelchat Expert
29/05/2018 - 10:40

easiest way I could think of.

User
29/05/2018 - 10:40

awesome thank you !!

User
29/05/2018 - 10:40

will def reccomend

Excelchat Expert
29/05/2018 - 10:40

:) thanks so much.

Excelchat Expert
29/05/2018 - 10:40

All the very best and have a great day ~

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*