Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Using shapes in bar charts

    Excel 2010 has a fair number of styles for charts like bar charts. Suppose I want to make the bars all cylinders rather than what Excel uses. I might be missing something obvious, but don't see where I can change the bar style to another shape type. Possible?

    Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Excel can use blocks, cylinders, cones, and pyramids all by changing the chart type. Right click the chart and then select "Change chart type"

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Hi, Steve. That part I knew...I was wondering and hoping there was a way to use "any" shape for the bar rather than those preassigned. No method jumped out at me.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I know of no way to change the shape, but you can use graphics by modifying the fill. I have attached an example using a moneybag graphic.

    Steve
    Attached Files Attached Files

Posting Permissions

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