Creating an excel graph

[Creekleo]

Hello Community,

i want to create a visual graphic based on the table below.
What is the ideal solution for a visually appealing graph.

thanks

	X1	X2	X3
2019	26,9	0,8	494
2020	26,9	1,5	686
2021	33,1	1,8	825
2022	33,2	1,6	740
2023	29,5	1,5	705

 

[awoohaw]

wow, all three series values are very unrelated.
What is the mean of the values in the series? Is there another trend or value that you can display?

This is my best stab at it. (Column charts did not look good either!).

 

[rlv01]

When I want to code VBA to create a graph from a table of data, I do it this way.

1. Spend time manually creating graphs from the table. Work out how I want it to look. Get the formatting right (legends, title, axes-labels, series colors, tick marks, etc)
2. Once #1 is complete. I use the macro recorder to record a macro as I manually create a chart with the look/format I want.
3. I study the code generated by the macro recorder, clean it up, and use it as the basis to code my final subroutine to create the graph.

 

[JV0710]

Hi , Here is my attempt - 2 options