How to do an EXCEL Chart for 3 parameters

asokaw

asokaw

New Member
Joined
Jun 24, 2013
Messages
39
Office Version
  1. 2013
How to show below data in a excel chart

Module 1-Nov-Plan 1-Nov-Actual 2-Nov-Plan 2-Nov-Actual
Mod - 1 70% 72% 32% 62%
Mod - 2 61% 62% 62% 74%
Mod - 3 60% 47% 60% 56%
Mod - 4 53% 46% 59% 60%
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Something like this:

1700585981983.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

asokaw
  • Locked
  • Question
What is the best way to show below data using an Excel Chart. Module/ Daily Plan / Daily Actual / % achieved
Replies
1
Views
69
Fluff
Fluff
K
  • Question
conditional formatting question
Replies
2
Views
171
kerm007
K
S
  • Solved
need to add * if score are less then 50
Replies
5
Views
466
JamesCanale
JamesCanale
togenmoser
  • Solved
Finding all possible combinations of 2 sums
2
Replies
10
Views
234
togenmoser
togenmoser
A
  • Solved
how to protect sheets vba code
2
Replies
19
Views
806
Scuba94
S

Forum statistics

Threads
1,215,253
Messages
6,123,891
Members
449,131
Latest member
leobueno

Share this page

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