+ Reply to Thread
Results 1 to 2 of 2

Charting Features

  1. #1
    mjones
    Guest

    Charting Features

    Hi,

    I'm having to re-create a 3D barchart (vertical bars) in Excel which
    was built in Ilustrator by designers. The chart has to be editable by
    many different users by updating the data. Some users have Excel 2003
    and others have 2002. My question is can Excel handle it or should I
    look at third-party software? Here are some of the features I'm
    struggling with:

    - spacing between bars to vary (i.e. space between Y-axis and then next
    two bars together)
    - full-range of color choices everywhere by RGB or hex code (i.e.
    heading, grid lines)
    - 3D shading of the bars (i.e. the top and side will be a lighter or
    darker color)
    - good resolution for the grid lines (i.e. mine shows jagged lines)
    - altering the side of the legend's colored squares
    - having a small horizontal line extend toward the values shown on the
    Y-axis

    I'd really appreciate any comments. I need to control my client, but
    on the other hand, I need to know what is possible.

    Thanks,

    Michele


  2. #2
    Tushar Mehta
    Guest

    Re: Charting Features

    Some of what you want to do is possible either natively in XL or can be
    simulated though possibly only in a limited manner. Other items (full
    range of colors for example) are not.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > Hi,
    >
    > I'm having to re-create a 3D barchart (vertical bars) in Excel which
    > was built in Ilustrator by designers. The chart has to be editable by
    > many different users by updating the data. Some users have Excel 2003
    > and others have 2002. My question is can Excel handle it or should I
    > look at third-party software? Here are some of the features I'm
    > struggling with:
    >
    > - spacing between bars to vary (i.e. space between Y-axis and then next
    > two bars together)
    > - full-range of color choices everywhere by RGB or hex code (i.e.
    > heading, grid lines)
    > - 3D shading of the bars (i.e. the top and side will be a lighter or
    > darker color)
    > - good resolution for the grid lines (i.e. mine shows jagged lines)
    > - altering the side of the legend's colored squares
    > - having a small horizontal line extend toward the values shown on the
    > Y-axis
    >
    > I'd really appreciate any comments. I need to control my client, but
    > on the other hand, I need to know what is possible.
    >
    > Thanks,
    >
    > Michele
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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