1 / 13

ASK an Expert Responds

Get answers to common chart customization questions - adjust frequency of X-axis labels, reverse rows and columns, add text and legend - with Mekko Graphics.

edwardsjoseph
Download Presentation

ASK an Expert Responds

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ASK an Expert Responds David Goldstein February 2019

  2. Managing Labels Q: How do I adjust the frequency of X axis labels? Jacob

  3. Managing Data Q:It is often easier to load lengthy datasets as many rows rather than many columns (because spreadsheets are typically built that way). Is there a way to tell the chart software to reverse the rows and columns for how it creates series? Jeff

  4. Adding Text to a Chart Q: I am trying to create a pretty simple bar graph and I would like to include a note about each bar. The note is in a row in an excel spreadsheet. Samantha

  5. Adding Text to a Chart Q: I am trying to create a pretty simple bar graph and I would like to include a note about each bar. The data takes up 3 columns in an excel spreadsheet. The note that corresponds to the data is in column C. Samantha

  6. Adding a Legend Q: I am using a Bar Mekko where I have colored each bar by geographic region (5 regions). I'd like the legend to reflect the colors of each region. Tedd

  7. Adding a Legend Q: I am using a Bar Mekko where I have colored each bar by geographic region (5 regions). I'd like the legend to reflect the colors of each region. Tedd

  8. Company Colors & Font Q: How can I download my company's standard palette and font into Mekko Graphics so that my charts match the rest of my presentation? Georgiann

  9. Applying Cell Colors Q: Is there any option to link the color of the cell to the bars of the chart? Gabriela

  10. Excel Formatting Q: If I created a chart and like the formatting I did, how do I seamlessly copy that formatting onto another chart in Excel? Kayla

  11. Chart Animation Q: How do I animate a Mekko Graphics chart in PowerPoint? I use the stacked bars to tell a story and don’t want to show the punch line too soon. Brandon 80 70 60 60 Services 45 40 Services 40 20 Products 25 Products 20 0 Current Year Next Year

  12. Chart Animation Q: How do I animate a Mekko Graphics chart in PowerPoint? I use the stacked bars to tell a story and don’t want to show the punch line too soon. Brandon

  13. Resources Learn more about how to use Mekko Graphics to improve your charts. For questions or product feedback, email me at david@mekkographics.com. Charts Videos Blogs & Support • Visit The Power of Mekko Charts to learn how to use marimekko and bar mekko charts • Visit All About Cascade Charts to learn how to use the different types of cascade charts • Download our chart gallery with more than 200 charts • Watch a recorded version of the full training webinar for step-by-step instructions on how to make each chart type • Watch short videos on key chart types, analytical enhancements and productivity boosters • Use our Chart of the Week blog for inspiration • Visit our Build Your CQ blog for tips and tricks to improve your charting proficiency • Use Ask an Expert from the Mekko Graphics ribbon or on our website if you’re struggling to find the right chart for your data

More Related