-
1. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Naveen BAug 9, 2018 6:14 AM (in response to Mikhail Christiansen)
Hi Mikhail ,
is this the way you are expecting
Hope this helps , Plz find the attached workbook.
Kindly mark this answer as correct or helpful so that it will be helpful to others
BR,
NB
-
2. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Mikhail Christiansen Aug 9, 2018 6:21 AM (in response to Mikhail Christiansen)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
-
3. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Naveen BAug 9, 2018 6:25 AM (in response to Mikhail Christiansen)
Hi Mikhail could you please attach same workbook which you posted as image will try to get into one sheet
BR,
NB
-
4. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Mikhail Christiansen Aug 9, 2018 6:28 AM (in response to Mikhail Christiansen)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
-
5. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Naveen BAug 9, 2018 6:28 AM (in response to Mikhail Christiansen)
Yeah let me know if any issue will try to see if any other workaround will help to solve the problem
BR,
NB
-
6. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Zhouyi ZhangAug 9, 2018 6:31 AM (in response to Mikhail Christiansen)
Hi, Mikhail
Probably you can use place holder as shown below with some calculation like min(1) for text and measure for your real bar chart.
Hope this helps
ZZ
-
7. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Mikhail Christiansen Aug 9, 2018 6:34 AM (in response to Naveen B)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.
-
9. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Mikhail Christiansen Aug 9, 2018 6:48 AM (in response to Naveen B)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
-
10. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Naveen BAug 9, 2018 6:52 AM (in response to Mikhail Christiansen)
Here you go attached the workbook
Hope this helps
BR,
NB
-
11. Re: How can I show table and bar chart on one worksheet with a group that is repeated?
Mikhail Christiansen Aug 9, 2018 7:04 AM (in response to Naveen B)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