• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. patricia

    Grid lines

    Thanks Wally. I had briefly considered that but thought no it is not a border. That will teach me :) Worked perfectly - thanks.
  2. patricia

    Grid lines

    This is probably basic but it is eluding me. I have 2 columns - A column of numbers and a column of related data bars. I removed the grid lines from the worksheet and then used the Camera to paste the 2 columns into another worksheet that also did not have grid lines. The data bars column looks...
  3. patricia

    Example database for dashboard

    Shane Devenshire posted a database on the Olympics that is available. He just asks that people download from the link so he can track its popularity. https://www.dropbox.com/s/uky41gfsxfidiaq/Olympics%202016.xlsx?dl=0
  4. patricia

    Custom Function - Documentation

    Hi I have created a custom Excel function and when someone accesses it from the Insert Function dialog box I would like to have a description display there or for the users to be able to click on the Help in the Insert function box to get more information as to what this customized function...
  5. patricia

    Any Idea on how to add PowerPivot to 2013?

    Hi Asheesh- Yes I tried those. My version does not have the add-in and apparently Microsoft opted to leave it out of Excel Standard. If you didn't buy the high end version apparently you don't get power pivot. Just trying to figure out a work around before I reinstall Excel 2010 and then go and...
  6. patricia

    Any Idea on how to add PowerPivot to 2013?

    Hi- I just upgraded to Office 2013 so that I could use 2013 however it appears that Microsoft only included it in the Pro Plus version. Has anyone had any luck in installing it in Excel 2013 - Standard Version? All help appreciated. Thanks. (only reason I bought 2013 was for power pivot!)
  7. patricia

    System changing my Excel file from .xls to .xlsx

    Has anyone run into this before? I upload a very simple Excel 2010 file that I saved down to the 97-2003 format level to my website. When I then try to download it, I get a message saying the file may be corrupted and that it has an invalid file format and it displays the file name with the...
  8. patricia

    Excel and PowerPoint 2010- Linking an Excel Chart into PowerPoint

    I guess this is more of a powerpoint question but does anyone know what the purpose of Paste>Keep Destination Theme & Link and Paste>Use Destination Theme & Data is in PowerPoint. I wanted to link an Excel chart into Powerpoint and thought this was a new way to link reather than using...
  9. patricia

    Using Offset Horizontally

    Hurray! Both methods worked. Kanti- using the #n/a is a nice and quick approach.I think I must be brain dead or need new glasses - in the Offset I kept putting a 1 in the row instead of the column and just kept repeating the same error over and over- Egads! Thanks again.
  10. patricia

    Using Offset Horizontally

    Thanks for all the help. I appreciate it.
  11. patricia

    Using Offset Horizontally

    HI Luke- Thanks for the welcome. What I am trying to do is add columns to a chart and have the chart pick them up automatically as they are entered instead of having it pick up rows automatically. For example, I have a chart that graphs product sales by month. In Column A, I have Products at...
  12. patricia

    Using Offset Horizontally

    Has anyone used Offset to add columns of data to a chart rather than rows? I've played around with it and have never been successful in getting OFFSET to work with columns. Any suggestions appreciated. Thanks.
Back
Top