Line graphs with data point as markers

crave4excel

New Member
Joined
Feb 2, 2012
Messages
45
Hello!
Got a question on Excel line charts.

Is it at all possible to create a simple line chart to show percentages, but replace the 'marker' with data points? For example, i have 40%, 50% and 60% in a line graph but instead of showing markers in various shapes, i want to show the actual percentages, and between each percentage is still connected by the line?

Any guidance is appreciated!

Thank you
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Your question isn't 100% clear to me, but perhaps you just need to add data labels, rather than using markers?
 
Upvote 0
You can link to an online one using a site like imgur, or put one on say OneDrive or Dropbox and post a link to it here.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top