+ Reply to Thread
Results 1 to 3 of 3

What Chart type is used for a dataset that has 2 dimensions

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    What Chart type is used for a dataset that has 2 dimensions

    Hi,

    I have Emailcombination patterns in Column B and Regions in Row2 underneath which I have the counts for Email patterns for that region .

    I want to have this information look more concise (of course chart) but not sure which chart type can show all dimensions of this data set

    Help would be greatly appreciated
    Attached Files Attached Files
    Teach me Excel VBA

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: What Chart type is used for a dataset that has 2 dimensions

    Have you tried the basic built in charts like line or column or bar? I would probably try those and see what I get before getting more complicated.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: What Chart type is used for a dataset that has 2 dimensions

    Alright

    Pivottable and PivotChart solved the issue. Thanks for your review as well

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Resizing Dimensions of Chart in Chart Sheet
    By Kabouterke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-16-2018, 02:20 PM
  2. [SOLVED] Divide in a panel type dataset
    By knm10 in forum Excel General
    Replies: 3
    Last Post: 03-02-2017, 06:57 PM
  3. [SOLVED] Macro to copy the image attributes eg. name, size, type, dimensions from folder containing
    By busybee235 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2014, 11:32 AM
  4. [SOLVED] Vertical chart dataset needs to be converted into pivotable dataset
    By aspak84 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-17-2013, 06:06 PM
  5. Bubble Chart with 5 dimensions
    By Judith Johnson in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2013, 02:48 PM
  6. [SOLVED] Plotting 4 dimensions in a chart
    By Garam Chitti in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2005, 08:05 AM
  7. [SOLVED] Adding a line Chart Type to a stacked-clustered Chart Type
    By Debbie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1