Hello,
I am trying to build treemap graphs for a presentation that will be in PowerPoint. I know that I am not using the chart function exactly as planned but am hoping someone can help. I have created the following treemap, but am having issues with double labels showing up on the graph. Here is the graph:
Treemap_Issue2.png
And here is my data spreadsheet for the graph:
Treemap_chart.png
Thank you for your help in fixing this issue!
Amanda
Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired results are also shown (mock up the results manually).
3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
4. Try to avoid using merged cells as they cause lots of problems.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I created the treemap in PowerPoint. I am not able to upload the PowerPoint file as it says it is an invalid format. However, I attached the excel file that was used to copy into the PowerPoint. My goal is to fix the double label issue on the charts. In the pictures in my original post you can see the double label issues I am having.
Re: Treemap Issues
You mean like this one?
(btw. I forgot to delete series2)
if you don't want Banner1, Banner2... etc set it to none
banner.jpg
Last edited by sandy666; 04-23-2018 at 11:17 AM.
Yes, that is what I would like the chart to look like.
So you've
datalabels.jpg
separator is optional
If that takes care of your original question, & to say Thanks, pleaseIf you did it already - ignore it.
- click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then- select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
Thank you.
Last edited by sandy666; 04-23-2018 at 11:23 AM.
I changed it to none in my PPT. But I am still having issues with the label. The forum will not let me post a link to the PPT file. Anyone know how I can share that?
zip it and attach
but this is Excel sub-forum not a PowerPoint
problem with labels are resolved, isn't it ?
I know this isn't a PPT forum, but my issue is with the chart in PPT that is created the same way it would be created in XLS. We create all our charts in PPT so it is easy for everyone to make the changes in one file and not multiple to have a chance in errors. I have attached a zip file of the PPT with the chart that shows the double label issue I am having. Thank you for working with me to identify the issue!
Re: Treemap Issues
but what is wrong with ppt? i see labels and percents as you wanted, so ?
I don't know what r you doing there but maybe this one:
paste - keep source formatting
Last edited by sandy666; 04-23-2018 at 12:19 PM.
If you look at the chart on the left, the purple box has a label in white and a label in black. Hence the "double label" issue. Similar to the original picture I posted in this thread.
refresh thread and see attached zip file
Re: Treemap Issues
All what you want to see in PPT you must prepare in Excel, then copy/paste (source formatting/destination - choose one)
Your "picture" in PPT should be linked to your source excel file automatically.
for the rest of problem with PowerPoint go to PowerPoint sub forum.
Last edited by sandy666; 04-23-2018 at 12:50 PM.
Looks like the data labels are screwed up for some reason. I can not replicate using your data in either ppt or xl.
What if you delete and reapply data labels, does the issue remain?
you can try
from your ppt
right click on label and
- Format Data Labels
- Text Options
- Text Fill => no fill
but this is eliminating the consequences of the problem not solve double labels problem in your PPT
Last edited by sandy666; 04-24-2018 at 08:10 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks