Which postal codes are available on cartogram chart
I want to show some data on the cartogram chart - thousands of records which belong to certain postal codes. Basically this works fine using the cartogram chart. I have a Country row, postal code row and a value row. The problem is that some postal codes are not known (Germany and Austria) but they are found in e.g. USA (even though I do use the country row). This makes the chart impossible to use because instead of Germany I see nearly the whole world. Land PLZ Wert Deutschland 80331 20 Deutschland 80333 20 Deutschland 80335 20 Deutschland 80336 20 Deutschland 80337 20 Deutschland 80339 20 Deutschland 80469 20 Deutschland 80538 20 Deutschland 80539 20 Deutschland 80634 20 Deutschland 80636 20 Deutschland 80637 20 Deutschland 80638 20 Deutschland 80639 20 Deutschland 80686 20 Deutschland 80687 20 Deutschland 80689 20 Deutschland 80796 20 Deutschland 80797 20 Deutschland 80798 20 Deutschland 80799 20 Deutschland 80801 20 Deutschland 80802 20 Deutschland 80803 20 Deutschland 80804 20 Deutschland 80805 20 Deutschland 80807 20 Deutschland 80809 20 Deutschland 80933 20 Deutschland 80935 20 Deutschland 80937 20 Deutschland 80939 20 Deutschland 80992 20 Deutschland 80993 20 Deutschland 80995 20 Deutschland 80997 20 Deutschland 80999 20 Deutschland 81241 2 Deutschland 81243 2 Deutschland 81245 2 The above data works nice - but change the postal code from e.g. 81243 to 81242... Any hint how to either remove not working postal codes or show just Germany/Austria on the cartogram chart?Currency Formatting adding additional periods to number
Hi, This has started happening on Excel and its baffling me so I thought I'd reach out to the community to see anyone can help. This is Excel v2606 (M365) with latest updates. Issue: I have a new work book and in a cell I simply add the number 20 I right click the cell with the 20 in it and select "Format Cells.." and change it to currency and this happens If I go back into "Format Cells" the selection has moved from Currency to Custom and it shows this: And clicking on Currency the format is shown as this: No matter what I do I can't get it to format correctly, if I change the format back to "General" it goes back to being 20. I've tried doing an online repair and that hasn't had any affect. Any help gratefully received. Rob
how to ignore conditional formatting for a cell that is not empty but invisible (cell format ;;;)
hi, i need help with a conditional formatting of cells that are not empty but invisible (cell format to ;;; (invisible)). I have a calendar where the dates are invisible (outside of the month) but the cell formatting applies to it (cuz it is that date, i.e., public holiday). i have attached the screenshots and i hope someone can help me out. thank you so much. regards, angel
chart change
I have an excel spreadsheet with several tabs. 4 of those tabs have charts. On my first chart, the information is no longer displaying correctly. I have deleted and readded, compared formating, used google. I cannot figure out why it is different. Only one of my chart lines is showing, the rest are so small I can barely see them and the heading color key won't display. - If I post this twice, apologies, I backed out accidentallySpacing on stacked bar charts
Hi all, I searched for a solution, but changing to 'text' axis doesn't work and that's the only solution I have seen offered. Issue: When using a date axis, there is too much white space / bars are too skinny to be legible despite gap width set all the way at 0. When switching to a text axis, the bar spacing is perfect, but the spacing between dates are at times nonsensical or for some reason it thinks the range is way different than what is highlighted. Here is how the data is highlighted, I only hid columns to make the picture a reasonably proportion the screenshots from above are when no columns are hidden. Is there a way to re-scale the gap-width when using a data axis to effectively to go something like -50%? Or to somehow manipulate the range and the months between labels when using a text axis? Thank you for the help. Matt
Stock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?How to wrap table, not vector (WRAPCOLS for tables)
Dear colleagues I have a long table of 5 columns and maybe 200 rows. The task is to wrap the table after a specified number of rows to see the table in landscape on a new sheet. I was thinking about WRAPCOLS, but it works only for vector (one column). Is there a way to wrap whole table using M365 functions? If not, the next option can be Power Query. See example attached. Thank You very much for any hint. Zdenek Moravec Cesky Krumlov, Czechia
multi Vehicle maintenance log record
i need to make a vehicle maintenance log that will have 7 different vehicles, track all the oil changes, inspections, registrations that will notify us when something is expiring, and be able to attach receipts and documents to it. what is the best way to do this?
