vba傳遞圖表設計
重點 (Top highlight)
It’s a regular Monday morning. All the design team is organizing the tasks for the ongoing week and reviewing requirements and deadlines for the various projects at the studio or company you work at. Suddenly, among the tasks that are being assigned to you, one of them stands out, but you can’t quite figure out why. Maybe, the task requirements are too few or too abstract, possibly leading to multiple interpretations. Perhaps, the task comes from a client or project you haven’t previously worked with. Or, maybe, the task’s description simply doesn’t make sense to you because you don’t have a proper context for it. Whatever the cause, it simply comes across to you as an “odd” task to carry out. But you try to ignore these signs, and simply move on, thinking that, somehow, you will figure it out on the way.
這是一個正常的星期一早晨。 所有設計團隊都在組織為期一周的任務，并在您工作的工作室或公司中審查各種項目的要求和截止日期。 突然，在配置設定給您的任務中，其中一項脫穎而出，但您還不知道為什麼。 也許，任務要求太少或太抽象，可能導緻多種解釋。 也許，該任務來自您之前未使用過的客戶或項目。 或者，也許任務的描述對您根本沒有意義，因為您沒有适當的上下文。 無論是什麼原因，它都隻是作為一項“奇特”任務來執行。 但是，您嘗試忽略這些迹象，而繼續前進，以為以某種方式您會發現它的。
You don’t know it yet, but you have made a big mistake. As the week passes, and the time comes when you finally need to work on your “odd task”, you find yourself feeling more and more lost about it. Where to start? How to tackle it? The more you wonder, the more lost you feel. That teeny-tiny task that seemed harmless in the Monday planning, has suddenly become a big headache for you. And, then, out of the blue, one of the most feared stages for any creative out there, shows up. Behold the creative block!
您尚不知道，但是您犯了一個大錯誤。 随着一周的過去，終于到了需要完成“奇異任務”的時機，您會發現自己對此感到越來越失落。 從哪兒開始？ 怎麼解決呢？ 您越想知道，您就會感到越失落。 在星期一的計劃中看起來無害的小任務突然讓您頭疼。 然後，突然出現了所有創意中最令人恐懼的階段之一。 看一下創意區！
Does this situation ring a bell? I bet it does! It’s something that has happened to pretty much any designer around the globe at least once in their career path. But, don’t worry! Today I want to help you shed some of your insecurities away. Through this article, I’ll show you why not knowing how to solve a particular task may not be to blame on a lack of professional skills or knowledge. Moreover, you will see, that the root of most creative blocks comes from not asking the right questions at the right time.
這種情況會響起嗎？ 我敢打賭！ 這是全球幾乎所有設計師在其職業道路上至少發生過一次的事情。 但是，不用擔心！ 今天，我想幫助您擺脫一些不安全感。 通過本文，我将向您展示為什麼不了解解決特定任務的原因可能不是歸咎于缺乏專業技能或知識。 此外，您會看到，大多數創意障礙的根源在于沒有在正确的時間提出正确的問題。
VS。 為什麼-問題類型 (How Vs. Why — Types of Questions)
Pretty much every organization out there will tell you that the work THEY are doing is important, and they will give you an abundant amount of reasons as to why it is. However, have you ever stopped to wonder about the job YOU are doing inside that organization? Is it truly important? Or relevant? What implications does it create? Why are you doing it, to begin with? What is the purpose behind it? And why do you keep doing it? These are fundamental questions any of us should try to answer for our own wellbeing, as exploring their answers may greatly benefit us both in our personal and professional spheres.
幾乎每個組織都會告訴您他們正在做的工作很重要，并且他們會為您提供很多理由。 但是，您是否曾經停止懷疑您在該組織中所做的工作？ 真的重要嗎？ 還是相關的？ 它會産生什麼含義？ 首先，您為什麼要這樣做？ 它的目的是什麼？ 為什麼要繼續這樣做呢？ 這些是我們任何人都應該為自己的幸福而回答的基本問題，因為探索他們的答案可能會極大地有益于我們的個人和專業領域。
“How we spend our days is, of course, how we spend our lives.” — Annie Dillard
“當然，我們的生活方式就是我們的生活方式。” —安妮·迪拉德(Annie Dillard)
Given that on average an adult human being devotes over 90,000 hours of their lives into the job they do, it is safe to say that most of us would value investing most, if not all, of that time in doing work that fulfills us. However, this may prove not to be such a simple goal to achieve, once that reality hits you. More often than not, designers tend to complain about being “blocked” at work, having all sorts of doubts and insecurities about the work they do, being unable to fully commit to the work they need to complete at a certain moment. Is this design good enough? Will it meet the client’s expectations? Could one of my colleagues have done a better job at it? Am I good enough at the job I do? Questions fill our minds, cloud our judgment, and, no matter what we try, it seems as if the black canvas in front of us simply rejects our creative endeavors.
鑒于成年人平均将90,000多個小時的生命投入到工作中，可以肯定地說，我們大多數人會珍惜這段時間中的大部分時間(即使不是全部時間)投入到使我們滿意的工作上。 但是，一旦現實降臨，這可能就不是那麼簡單的目标。 設計師常常會抱怨他們在工作中“受阻”，對他們所做的工作有種種疑問和不安全感，無法完全緻力于他們在某一時刻需要完成的工作。 這個設計夠好嗎？ 會滿足客戶的期望嗎？ 我的一位同僚能做得更好嗎？ 我的工作能力夠嗎？ 問題充斥着我們的思想，遮蔽了我們的判斷力，無論我們嘗試什麼，似乎擺在我們面前的黑色畫布都隻是拒絕我們的創造性努力。
There are two questions you should ask regarding your work: WHY you are doing it and HOW you are doing it. 關于您的工作，您應該問兩個問題：為什麼要做和如何做。
It is clear that you may not always be able to carry out tasks that excite you. However, you should be able, at all times, to understand WHY you are doing what you are doing. Because if you don’t, you will most likely fall into a dead-ends loop. Design requires a level of curiosity and imagination that can’t adequately be propelled from automatized thoughts and behaviors, but require meaningful intentions that make room for real innovation. Sitting in front of your desk, searching for references from others’ work, and “creating” a design base on those references, should hardly be considered as a creative effort.
很顯然，您可能并不總是能夠執行使您興奮的任務。 但是，您應該始終能夠了解為什麼要執行自己的操作。 因為如果不這樣做，您很可能陷入死胡同。 設計 需要一定程度的好奇心和想象力，不能從自動化的思想和行為中獲得足夠的推動力，但需要有意義的意圖，才能為真正的創新留出空間。 坐在辦公桌前，從他人的作品中尋找參考，并基于這些參考“建立”設計，幾乎不應被認為是一項創造性的工作。
Don’t get me wrong, I’m not neglecting the importance of finding knowledge and enlightenment in the work done by others. However, there’s a big difference between inspiration and imitation. If the goal for those references you are seeking is only to serve as fuel to your creative process and outcomes, then everything is ok, but if you are seeking those references to take bits of every one of them and mix them into a “new design”, well… that’s a whole different story. You’ll find little room for personal and professional growth by imitating others, in comparison to what you could create by finding your own “spark”. Creating is not easy, but it can be extremely satisfying when done well.
不要誤會我的意思，我并沒有忽略在他人所做的工作中尋找知識和啟發的重要性。 但是，靈感和模仿之間有很大的差別。 如果您要尋找的這些參考文獻的目标隻是為您的創作過程和成果提供動力，那麼一切都很好，但是如果您正在尋找這些參考文獻以将每一個參考文獻的每一部分都融入其中，然後将它們混合成一個“新設計” ”，嗯……那是一個完全不同的故事。 與通過尋找自己的“火花”可以創造的東西相比，通過模仿他人，您将找不到個人和職業發展的空間。 建立起來并不容易，但是做得好的話可能會非常令人滿意。
Now, comes the trick: you could ease a lot of your efforts as a designer if you could manage to balance the HOW and WHY questions behind your work. Some of the imperfect relationships designers have with their work often come from attributing an imbalanced level of importance to HOW they make their work, over WHY they are making it. Even though both questions are valid and important, one should discern when it is useful and necessary to ask each of them. HOW should follow WHY. Craft should follow purpose. Every decision should have a valid reason behind it. And before you even take a pen and paper, you should understand the underlying reasons for the task you are performing.
現在，訣竅到了：如果您可以設法平衡工作背後的HOW和WHY問題，則可以減輕作為設計師的工作量。 設計師與工作之間不完美的關系通常來自于将不平衡的重要性歸因于他們如何進行工作，而不是為什麼進行工作。 即使這兩個問題都是有效且重要的，但應該辨識何時才是有用和必要的問題。 如何遵循為什麼。 Craft.io應遵循目的。 每個決定都應有正當理由。 而且，在甚至拿筆和紙之前，您應該了解執行任務的根本原因。
A creative process is like a ladder, every step you take forward, matters. 創新的過程就像一個階梯，前進的每一步都很重要。
The creative process could be said to resemble a ladder, where the bottom rung is the blank page and the top rung the final piece. In between, the artist climbs the ladder by making a series of choices and executing them. Many of our conversations about creative work are made lame because they concern only the top rung of the ladder — the finished piece. We must talk about those middle rungs, understanding that each step up the ladder is equal parts Why and How. To only entertain one is to attempt to climb a ladder with one foot: it may be possible, but it is a precarious task. — Frank Chimero
可以說創作過程就像一個梯子，底部的梯級是空白頁，頂部的梯級是最後一頁。 在這兩者之間，藝術家通過做出一系列選擇并執行它們來爬上階梯。 我們有關創意工作的許多談話都la腳，因為它們隻涉及階梯的最高梯級-成品。 我們必須談論那些中間的梯級，了解梯子上的每一步都是為什麼和如何相等。 隻招待一個人就是試圖用一隻腳爬一個梯子：雖然可能，但這是一項艱巨的任務。 — 弗蘭克·奇梅羅
By properly articulating WHY and HOW questions into your work, you will create a motion that allows you to confidently move forward at the same time that you keep your work firmly grounded. By asking first WHY you will gain a deep understanding of the work you are doing in a way that enables you to find a place for creativity and invention, and later, by asking HOW you will find new ways to refine your craft and elevate the form of your design.
通過在工作中正确表達“為什麼”和“怎麼做”問題，您将建立一個議案，使您可以自信地向前邁進，同時牢牢紮根工作。 首先要問為什麼，您将以一種可以使您找到創造力和發明的地方的方式對自己正在做的工作有深刻的了解，随後，通過問如何将找到改進Craft.io和提升形式的新方法，您将獲得深刻的了解您的設計。
在正确的時間提出正确的問題 (Asking the Right Questions at the Right Time)
Sometimes, not asking questions can come from fear. Fear of sounding naive or ignorant, fear of showing a lack of skills or knowledge, fear of going against the status quo, or even fear of not getting the answers we would like to hear from others — whether those others are our users, colleagues, or stakeholders. But we must be brave enough to ask others WHY. As designers, we strive to innovate for the better, and innovation always requires taking risks. But those risks need to be calculated, and they must have purpose and meaning in order to achieve the desired outcomes. We must ask WHY even if it makes us or others uncomfortable. Furthermore, we should definitely do it if a given question spurs all sorts of discomfort because that may be a sign of underlying issues permeating the very design we are working on.
有時候，不問問題可能來自恐懼。 害怕聽起來天真或無知，害怕表現出缺乏技能或知識，害怕違背現狀，甚至害怕得不到我們想從别人那裡聽到的答案-不管其他人是我們的使用者，同僚，或利益相關者。 但是我們必須勇敢地問别人為什麼。 作為設計師，我們緻力于創新，而創新總是需要冒險。 但是，這些風險需要進行計算，并且它們必須具有目的和意義才能實作預期的結果。 我們必須問為什麼，即使這會使我們或其他人感到不舒服。 此外，如果給定的問題引起各種不适，我們絕對應該這樣做，因為這可能是滲透到我們正在設計的基礎問題的征兆。
Designers have a tendency to live fighting against the clock, I know. We are always running to meet deadlines and deliver outcomes on time. That’s why we may sometimes be inclined to ignore whatever questions may arise in regards to a task, and, just directly dive into the hands-on part of designing. But, sometimes, trying to save time may actually cost us a great deal more at the end. Some questions may be solved as we move on through the design process. However, some others, fundamentally, require being answered before you even open any sort of design software. Any time you receive a task of requirement you must understand where does it come from, what are the reasons behind it, how did that task end up in your log.
我知道，設計師傾向于與時俱進。 我們一直在努力按時完成任務并按時傳遞成果。 這就是為什麼我們有時傾向于忽略與任務有關的任何問題，而直接進入設計的動手部分的原因。 但是，有時候，節省時間實際上可能會使我們最終付出更多的代價。 在我們繼續進行設計過程時，可能會解決一些問題。 但是，從根本上講，有些其他東西甚至在打開任何類型的設計軟體之前都需要得到回答。 每當您收到要求任務時，您都必須了解它來自何處，其背後的原因是什麼，該任務如何在日志中結束。
A matter that becomes clear ceases to concern us. — Friedrich Nietzsche
一件清楚的事情不再引起我們的關注。 - 弗雷德雷西尼采
發展觀點 (Developing a Point of View)
Time for a retrospective of your own creative process. 是時候回顧自己的創作過程了。
A problem well-defined is a problem half solved. — Charles Kettering
定義明确的問題是已解決一半的問題。 —查爾斯·凱特琳
So what comes next? Be prepared to bravely ask WHY next time you find yourself in front of another “odd” task. Do not fear, because fear can hold your professional growth and improvements back. I am not going to uselessly lift your hopes. Maybe, the results of your inquiry might not suit you at first, but they will open up possibilities to create better design outcomes. I will share with you a simple but effective exercise that you could (and ideally should) apply at the beginning of every design task you receive. The exercise is very straightforward. You just have to answer three questions with regards to the assigned task:
那麼接下來呢？ 準備好勇敢地問下一次您為什麼要面對另一個“奇特”任務時的原因。 不要害怕，因為恐懼會阻礙您的專業成長和進步。 我不會無用的提起您的希望。 也許您的詢問結果起初可能不适合您，但它們将為創造更好的設計結果提供可能性。 我将與您分享一個簡單但有效的練習，您可以(理想情況下)在收到每個設計任務時就應用該練習。 練習非常簡單。 您隻需要回答有關已配置設定任務的三個問題：
1. What problem are you solving?
1.您要解決什麼問題？
2. Who has this problem?
2.誰有這個問題？
3. What do you want to achieve by solving it?
3.您想解決什麼問題？
This exercise is called developing a POV (Point of View), a perspective of the problem you are working on that results in an actionable problem statement. A short and concise definition of the problem, that allows you to better find a place for new and innovative solutions. The scheme of the questions can, of course, be adapted depending on the design challenge you are facing. Maybe your task is no about solving a problem, but seizing an opportunity, or exploring a possibility for improvement. Nevertheless, the basic pattern should always be:
此練習稱為開發POV (觀點)，這是您正在研究的問題的觀點，它導緻可采取行動的問題陳述 。 對問題的簡短定義，使您可以更好地找到新的創新解決方案。 當然，可以根據您面臨的設計挑戰來調整問題的方案。 也許您的任務不是解決問題，而是抓住機會或探索改進的可能性。 但是，基本模式應始終為：
WHAT [ problem / opportunity / challenge exists ]
什麼[存在問題/機會/挑戰]
WHO [ is being impacted, or could be impacted, by it ]
世衛組織[正在受到或可能受到其影響]
WHY [ trying to resolve / explore / implement it is relevant]
為什麼[試圖解決/探索/實施它是相關的]
¿What are you solving? | ¿Who will be impacted? | ¿Why is it important? ¿您要解決什麼？ | 誰會受到影響？ | 它為什麼如此重要？
By asking yourself these questions, you will get into a mindset that pushes you to think about your task as something beyond a simple requirement. You will perceive it as a complex set of decisions, that may impact and have consequences on the final outcome, and which deserve a second thought. At first, this might feel like too much of a hustle, but the effort put into it will give you a foundation on which you can lean on as you develop the task. And you will thank yourself later when, in front of a blank canvas, you feel inspired rather than daunted by the possibilities it beholds.
通過問自己這些問題，您将進入一種心态，促使您将任務視為超越簡單要求的事物。 您會将其視為一組複雜的決策，這些決策可能會影響最終結果并對其産生影響，值得您三思。 剛開始時，這似乎有點麻煩，但是投入的精力将為您提供一個基礎，您可以在完成任務時依靠它。 稍後，當您在一塊空白的畫布上感到鼓舞，而不是被它所看到的可能性所吓倒時，您将感謝自己。
“And, what if I can not answer them? Then, what?” — some of you might wonder. There are two main possibilities when this happens. First, the task makes sense but you might not have a deep understanding of it, so you don’t know what might be the best path to follow through. If this is the case, you can seek support from your colleagues and try to gain knowledge and context about the reason why the task was conceived in the first place. Second, and the least pleasant scenario one can encounter, the task simply does not make sense. It doesn’t serve a real purpose, and, therefore, its future development may have unwanted repercussions. Being the least compromising repercussion, but still highly frustrating, to discover that the task does not have any impact at all. In other words, it was useless to do it from the very beginning.
“而且，如果我無法回答他們該怎麼辦？ 那呢？ -你們中有些人可能會感到奇怪。 發生這種情況時，主要有兩種可能性。 首先，這項任務很有意義，但是您可能對此沒有深刻的了解，是以您不知道什麼是最好的遵循方法。 在這種情況下，您可以尋求同僚的支援，并嘗試獲得有關任務最初構思的原因的知識和背景。 其次，這是人們可能遇到的最不愉快的情況，這項任務根本沒有意義。 它沒有真正的目的，是以，其未來的發展可能會産生不良影響。 發現該任務根本沒有任何影響時，它是影響最小的結果，但仍然令人沮喪。 換句話說，從一開始就沒有用。
Nobody wants to lose their time on meaningless efforts. Thus, I would advise you, if you are ever assigned a task that has no real or useful purpose, to speak up as soon as possible. Take another leap, using some of that bravery that you started to build since the very moment you ask WHY, and raise a red flag, by reaching out to your superiors, before it’s too late. This, of course, must be done and founded on strong and persuasive arguments that allow you to get everyone on the same page. If all goes well, you may save yourself and your team, time you can invest in focusing on the work that trully matters.
沒有人願意在毫無意義的努力上浪費時間。 是以，如果您被配置設定的任務沒有真正或有用的目的，我建議您盡快說出來。 采取另一個飛躍，使用自從您問WHY的那一刻起就開始建立的一些勇氣，并在為時已晚之前與您的上級聯系，舉起紅旗。 當然，這必須基于強大而有說服力的論據來完成，并建立在這些論據的基礎上，這些論據可以使每個人都在同一頁面上。 如果一切順利，則可以節省您自己和您的團隊的時間，您可以投入時間專注于重要的工作。
A great POV keeps you on track. It helps you design for your users and their needs. If you neglect to define your POV, you may end up getting lost in the ideation processes — Rikke Friis Dam and Teo Yu Siang on Interaction Design Foundation
出色的POV使您步入正軌。 它可以幫助您針對使用者及其需求進行設計。 如果您忽略定義POV，則可能會迷失在構思過程中-Interaction Design Foundation上的Rikke Friis Dam和Teo Yu Siang
Understanding the purpose behind the design work you make gives you more confidence to explore and be innovative. By answering, from the beginning, any kind of questions you might have regarding a certain challenge, you clear the way for the next steps to come in the creative process. So, be mindful and don’t let assumptions and doubts cloud your mind. Asking WHY is the first step, but, what you decide to do with the answers you get, defines you and your work as a creative. If you want your work to matter, you should ask yourself how much of you can be found in it. Do you speak through your designs? Or do you let others do the talking?
了解您所做的設計工作的目的使您更有信心進行探索和創新。 通過從一開始就回答您可能遇到的有關特定挑戰的任何類型的問題，您便為下一步進入創意過程掃清了道路。 是以，請保持警惕，不要讓假設和疑問籠罩您的思想。 問為什麼是第一步，但是，您決定如何使用所獲得的答案将您和您的工作定義為一個創意。 如果您希望自己的工作很重要，則應問自己可以在其中找到多少人。 您通過設計說話嗎？ 還是讓别人講話？
Life is too short to sing to the tune of others. So sing a song of your own.
人生苦短，無法唱别人的歌。 是以唱一首自己的歌。
翻譯自: https://uxdesign.cc/are-you-designing-just-for-the-sake-of-delivery-650f406cb3c3
vba傳遞圖表設計