Thread: Excel chart with a vertical line

Hey folks,

I hope someone can help me. I need this issue fixed for a presentation. Let me make a example. There were surveys about the average age of young people which are going into clubs. Germany was 23,4 years, Italy were 24,4 years, Franch was 19,0 years etc. The average European average is 23 years. I would like to use a bar-chart where the country average is shown. For the European average there shall be a vertical line which goes through the whole chart.

Can someone help? Thanks in advance

Originally Posted by dein_feind

Hey folks,

I hope someone can help me. I need this issue fixed for a presentation. Let me make a example. There were surveys about the average age of young people which are going into clubs. Germany was 23,4 years, Italy were 24,4 years, Franch was 19,0 years etc. The average European average is 23 years. I would like to use a bar-chart where the country average is shown. For the European average there shall be a vertical line which goes through the whole chart.

Can someone help? Thanks in advance

Add a new series with data for only the 'top' and 'bottom' so that you have bars that extend to where the average is. Right-click your new series that was created and go to chart type. Selcect x-y scatter plot. The rest is formatting.

Need to create a scatter chart that reflects the following:

Y Axis: 0.0 - 5.0
X Axis: Categories (Product Quality, Cost Effectiveness, Quality Support, Relationship, Innovation)
Legend: Right hand side of the chart show all of the customers
Have all of the customer Average in each category plotted on the same scatter chart and then have an average line going across the entire chart can I do this? Thanks!