Unable to overlap my bar chart series as the option is not there

R

RaidahHussain

New Member
Joined
Jul 25, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I want to overlap the series in my barchart, but i am unable to find the option under format data series
1595662719693.png
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Seems you are using 3d chart. Do not think they van overlap. Would become very difficult to read them btw.
Always use 2d is the advice charting experts would give.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Formatting data series for chart created via Slicer and Pivot Table
Replies
6
Views
301
awoohaw
awoohaw
O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
336
OrangeJuice
O
ExcelNewbie2020
  • Question
Result of Choosecols function to overlap to next parallel cells
Replies
1
Views
123
StephenCrump
S
E
  • Solved
Trouble creating vertical trendline on clustered bar chart in Excel 2016
Replies
4
Views
627
Jon Peltier
J
A
  • Question
Help Debugging Custom Data Label Macro
Replies
0
Views
135
arndtea
A

Forum statistics

Threads
1,215,036
Messages
6,122,794
Members
449,095
Latest member
m_smith_solihull

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