Bar Chart - Tough One..

building reports desktopintelligence
1

Hi - I am trying to show some numbers on the bar chart and not sure if there’s a way to do this. I want to display week average for each quarter and then weekly numbers on the same axis. I.e Display Q1 weekly average on one bar and same for Q2 but then display weekly numbers for Q3 and beyond (separate bar for each week). How can I do this? I have two variables defining quarters and weeks. I am not sure if I can display them as I need on the same axis.

Any help is greatly appreciated.

Thanks

BOaddictNYC (BOB member since 2003-07-11)

2

Would using a ‘Z’ axis work?

Mitra

Mitra Moini (BOB member since 2002-09-01)

3

I tried creating a variable for calculating each of the quarter and inserted as a Secondary Y-Axis but it overlaps with weekly values on the chart. Adds the Quartery average on top of the first weekly bar.

BOaddictNYC (BOB member since 2003-07-11)