DYNAMIC CHARTS USING OFFSET FORMULA

A

abduldrda

New Member
Joined
Dec 11, 2021
Messages
16
Office Version
  1. 365
Respected Sir/Madam,
I have created a dynamic chart using OFFSET function, with 1st Quarter, 2nd Quarter, 3rd Quarter & 4th Quarter as my criteria.
I have applied some FORMATTING like Labels, Bevel etc.
1st Quarter chart showing all the formatting I have done.
The applied formatting not showing from 2nd, 3rd & 4th quarters chart.
I hope I may get early reply in this regard.
Thank you.

Formula used:
OFFSET(Sheet1!$B$6,0,MATCH(Sheet1!$H$1,Sheet1!$C$5:$F$5,0),12,1)

Note: Sir, I didn't find any option to send my excel file. Thats why I am attaching the Images.
 

Attachments

  • 1. SOURCE DATA.jpg
    1. SOURCE DATA.jpg
    54.7 KB · Views: 6
  • 2. DROPDOWN LIST.jpg
    2. DROPDOWN LIST.jpg
    11.2 KB · Views: 6
  • 3. NAME MANAGER WITH OFFSET FORMULA.jpg
    3. NAME MANAGER WITH OFFSET FORMULA.jpg
    123.6 KB · Views: 9
  • 4. 1ST QUARTER SHOWING ALL LABELS AND FORMATTING.jpg
    4. 1ST QUARTER SHOWING ALL LABELS AND FORMATTING.jpg
    52.5 KB · Views: 11
  • 5. 2ND QUARTER TO 4TH QUARTER NOT SHOWING LABLELS AND BEVEL FORMATING.jpg
    5. 2ND QUARTER TO 4TH QUARTER NOT SHOWING LABLELS AND BEVEL FORMATING.jpg
    46 KB · Views: 10

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Sir, very sorry to bother. But, just know I made some adjustments to my above post.
1. UNCHECKED SHOW LEADER LINES option for SHOW LABELS
2. UNCHECKED Excel Options->Advanced->CHART->Properties follow chart data point for current workbook
I have closed & opened the file again. Now the labels and CHART BEVEL TYPE IS PRESERVED as I have left.
But, I couldn't apply DIFFERENT BEVEL OPTIONS for DIFFERENT OUTPUT.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Creating Auto Updating Charts
Replies
2
Views
622
Greencells
G
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
200
Nick Loughton
N
R
  • Solved
Custom Chart template when using slicer
Replies
2
Views
128
RodneyW
R
T
  • Question
Trying to get month name using a formula
Replies
2
Views
340
Peter_SSs
Peter_SSs
A
  • Solved
Ramp up formula with variable column start
Replies
4
Views
122
akatsuki
A

Forum statistics

Threads
1,214,968
Messages
6,122,506
Members
449,089
Latest member
RandomExceller01

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