Graphical representation based on size of value and time

[Peakey123]

Hi,

So I am trying to create a graph with time on the x axis and a list of opportunities on the y axis for various projects we would like to undertake. I would then like to be able to plot the various stages of the project over time for each opportunity (contract through to start), with this represented by a line graph with bubbles at each stage. However, I would like the size of the bubble at each stage to be smaller or larger depending on the monetary size of the project! Really complicated and not sure if possible but any help would be greatly appreciated! I have provided some dummy data below to show what I am working with:

Organisation	Project	Value	Contract	Release	Submission	Award	Start
Water	Honey	10	01/08/23	01/09/23	01/11/23	01/02/24	01/03/24
Cola	Comb	23	01/09/23	01/10/23	01/11/23	01/12/23	01/01/24

Thanks!

Peakey123

 

[GlennUK]

Can you mock up a graphic of what you expect the above data to look like? From your description I cannot work out what you are requiring.