Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. beadedbytes

    Excel 2013: Different Solution for Converting Summary Table to Data Table

    I've used a lot the Excel feature that allows conversion of a summary table to data table using the Pivot Wizard. Often times, the newly-created data table is subsequently used in a pivot table. This method has worked well when the 'values' created are the same format (i.e. number OR percent...
  2. beadedbytes

    Excel 2013: Map Graphing Options

    I'm hoping there's an easy option for using a map graph in Excel that would allow me to plot volume by state (or country). Currently, I see 'Bing Map' already built in, but it's not giving me the desired results. It's plotting which states have volume; however, I've been trying to figure out...
  3. beadedbytes

    MS Outlook 2013: How to Send Same Meeting Invite to Different (and Separate) Distribution Lists

    Hello. On a regular basis (i.e. bi-monthly), I need to send a meeting invite to 5+ partner companies to set up time to review activities that occurred the prior 2 weeks. Since we all are separate businesses coming to the same meeting, I want to be able to send the same meeting invite to each...
  4. beadedbytes

    Excel 2013 - Automating 'Custom' Data Labels

    Hello. Please see attached document (a picture is worth a thousand words). I've inherited a dashboard that contains a multitude of charts with data labels. The charts are primarily, not exclusively, stacked or single bar. The labels have been added manually and I'm looking for a much more...
  5. beadedbytes

    Excel 2013 - Combining Data with Different Number of Columns and/or Rows

    Hello, Is there an automated solution (without macros/VBA) for merging multiple Excel worksheets containing different number of columns and rows into one master? The worksheets are all located into one workbook. Thank you in advance for feedback.
  6. beadedbytes

    Outlook 2013 - Meeting Invite 'Tracked' Responses

    When sending out a meeting invitation, there's 3 options for accepting: 1. Edit response before sending 2. Send response now 3. Do not send a response I've learned that when the recipient uses option #3 to respond, they are listed under the Outlook's Tracking section as 'Response' = 'None'. In...
  7. beadedbytes

    Excel 2013 - Requesting Pivot Table Calculation Solution

    Please example below taken from part of a pivot table (exception: not included in pivot is column labeled as ‘Returns4’). Mailing# Week# Ct Mailed Returns1 Returns2 Returns3 Returns4 Mailing1 Wk01 500,569 41 41 2.43% 0.01% Wk02 0 335 376 22.31% 0.08% Wk03 0...
  8. beadedbytes

    Excel 2013: Challenges in Charting (using Combo Charts)

    Interesting oddities are occurring while creating approx. 40 charts using combo chart along with the Primary and Secondary feature. Details about my process: - Data table example is listed below. The fields and format are the same for all 40 charts - just the values change for each table...
  9. beadedbytes

    Excel 2013 - Combo Chart: Min-Max Range for One Field is Large

    I've been trying to create a Combo chart (bars and line) in Excel 2013 with both Primary and Secondary axes. Sample data is provided below with a pipe delimiter for parsing. (FYI ... 'Return%' field is actually displayed as a percent (e.g. 1st entry below of 0.04819 is actually shown as 4.9%.)...
  10. beadedbytes

    Excel 2013: Automated Way to Create Data Table for Pivot?

    I'm wondering if there's a somewhat automated way to generate a code listing that's based on common elements. I'm working with a data tool that allows one to pull customer data by selecting desired metrics. In addition to the CODE, a sampling of the metrics are listed below -- STATE, VERSION...
  11. beadedbytes

    Excel 2013: Formula to Count # of Days (Mon - Sat)

    Our work week is Mon through Sat (instead of Mon through Fri). Is there a formula (Excel function or created formula) that will count the number of workdays including Saturday but excludes Sun? Thanks in advance for feedback.
  12. beadedbytes

    Microsoft PowerPoint 2013: Reverse Slide Numbering - Possible?

    Is there a way to number the slides in reverse order in Microsoft PowerPoint 2013? I have a document that currently has 10 slide (pages) and the number of slides(pages) will grow over several months. We always want the current information to be at the front of the document instead of adding...
  13. beadedbytes

    Adobe Acrobat 9 Pro - 'Images Behind an Image'

    I'm wondering if the following can be accomplished. We regularly have PDFs that include images such as graphs. The graphs are usually some type of summary. For example, a graph may show Sales by a particular month. In an ideal world, I'd love to be able to click on the graph and then have...
  14. beadedbytes

    Excel 2013 - Data Bar Conditional Formatting in Pivot Tables

    Is there an easy way to assign like-colored data bars in 'one fell swoop' inside a pivot table? In other words, can columns that are to be colored orange be assigned at the same time? When I created the example below the first time, I did it for each individual column. I've attempted to...
  15. beadedbytes

    Excel 2013 - Formatting Numeric Axes Labels

    I need some help in changing the format of currency used as axes values. In the source data, the dollar values are: $17,939,065 $41,418,973 $7,692,284 $2,643,272 The axes values are 0--$10.0M--$20.0M--$30.0M--$40.0M--$50.0M. The Excel 'Format Code' used = $#,##0.0,,"M";$#,##0.0,"M";General...
  16. beadedbytes

    Microsoft Excel 2013 - Knowledge Requested about Calculated Fields in Pivot Tables

    I've recently created some calculated fields inside a Excel 2013 Pivot table. And, there seems to be some 'unexpecteds' when using them. Let's say I have a field with Source_Name='Rsp_Prcnt'. After creating the calculated field, I've assigned the metric Custom_Name='Resp%' as the Column...
  17. beadedbytes

    Excel 2013 - Extracting Data from Table using Multiple Values and Formatting Criteria

    For every 'Unit' listed in Column A, I'm trying to figure out how to extract certain information from the example grid below -- 'Unit X' with corresponding xx% and $xx,xxx. Also, for each Unit X xx% value, I want to extract the percent value in the column header. Using Unit 1 record as the...
  18. beadedbytes

    Seeking Google Analytics Advice for Quality Training

    Hi. I've started working in Google Analytics for a digital company. For basic questions (e.g. how to do xx, etc.), I'm able to find pretty good information on the internet. However, I'd like to take class that covers not only just the basics, but learn how to leverage GA to better track and...
  19. beadedbytes

    Microsoft Excel 2013 - Creating Database Table from Summary Table

    There's a solution I've used over the years from John Walkenbach's The Spreadsheet Page site. He gives great instructions for converting a summary table into a database table. Please check out the following link...
  20. beadedbytes

    Excel 2013 - Clustered Column Chart w/ Multiple Data Series

    Please see the example data below. In each Grouping (i.e. A,B,C), '-T' is the total audience for the Group; '-R' is a subset of the total audience. I've been trying to figure out how to create a clustered column chart that includes more than one Grouping per quarter (i.e. A-T/A-R, B-T/B-R...

Part and Inventory Search

Back
Top