The bar chart could even just overlay the 2nd number in the workbook (profit). I'm just not sure if this is possible. Ultimately, I would like something like this:

However, I would like to do this with only one worksheet instead of four here. Also, State does not need to be repeated. This is a really rough example.

Best,

Mikhail

Sorry, Naveen, I didn't see your response before I posted. I think your solution might work. I am going to play around with formatting right now in the actual workbook and will come back to update the question if it is correct.

THANKS!

If you get there first, feel free to post

Alright, I see what you both have done with the first workbook. This is not exactly what I am looking for. You are displaying a text and a bar for Sales and then a text and a bar for profit.

What I am looking for is in that updated workbook. A sales as text and profit as a bar chart for each product subcategory (columns). So, it would be repeated text & bar for Machines, then text & bar for Phones, etc.

If I use what you have currently done, then I could create a separate calculation for each category (IF [subcat] = "phones" then [profit] END) and then use those in place of what you have submitted, but this is a lot of extra calculations for the actual workbook and I would like to avoid this, if possible.

Hi Naveen B,

Can you post the workbook? I believe this is what I am looking for. I just need to explore it and make sure.

Thank you,

Mikhail

Naveen B - this is nearly perfect!

There is one thing left:

1) Is there any way to right justify or left justify the MIN(NumofRecords) column so it would appear as a normal number in a text table? I tried changing the formatting on the marks card, but nothing was actually affecting it.

Best,

Mikhail