Search:

Type: Posts; User: Jon Peltier; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.18 seconds.

  1. Replies
    3
    Views
    116

    Re: [VBA HELP] Copy Data.

    pt1 and pt2 are the variables used by VBA. I tried to make it easy, so you didn't have to rename pivot tables.

    The two pivot tables must have "Shipto" and "Mat Code" in their respective top left...
  2. Re: make chart axis labels hyperlink to other pages

    Is there a way you could share the workbook?
  3. Replies
    2
    Views
    155

    Re: Chart based on Store selection

    You can take the data just as you have, and convert the range into a Table. Select the range, press Ctrl+T, check my data has headers. I changed "Gross Sales" to "Store".

    Then make a chart from...
  4. Replies
    1
    Views
    116

    Re: Excel convert time to Custom

    If the cell has General format before you enter the time, Excel will pick a format based on your entry.

    If the cell has your favorite format before you enter the time, Excel will use the format...
  5. Replies
    11
    Views
    255

    Re: why giving me N/A?

    I can't find the workbook I used the other day when I first answered. But I've recreated it in this screenshot.

    The formulas I've posted (shown in column D) return #N/A and not zero if there is a...
  6. Re: Conditional Formatting for Gantt Chart not working

    You want to find out if a task begins in or before the quarter represented by column F, and ends in or after the quarter represented by column F, which happens if this formula is true:
    ...
  7. Re: Conditional Formatting for Gantt Chart not working

    Sorry, it was getting last last night, and I could barely think any longer. Maybe later...
  8. Re: Need help to copy a call value in all rows of a dynamic sized table

    Ctrl+D is D for "Down", maybe your localization has a similarly familiar keystroke to try.

    Anyway, if Ctrl+D doesn't work, copy P2 and paste it into P3, then select P2:P3 and double click the...
  9. Re: Conditional Formatting for Gantt Chart not working

    I figured that's what it was. So you need to work on those algorithms.
  10. Re: Need help to copy a call value in all rows of a dynamic sized table

    No code required.

    Select P3 and press Ctrl+D to copy the value there from P2.

    Select P2:P3, then double click on the fill handle, that small dark square at the bottom right corner of the box...
  11. Re: Conditional Formatting for Gantt Chart not working

    It would help to see what the dates are in the red cells. But it looks like the resolution of your grid for display dates is 3 months, and your resolution for start and end dates is days.

    If your...
  12. Replies
    3
    Views
    116

    Re: [VBA HELP] Copy Data.

    I wrote a bit of VBA. I assume:

    the two important pivot tables are on the same worksheet,
    there is only the one header row in the pivot tables,
    that the pivot tables can be reliably...
  13. Replies
    11
    Views
    255

    Re: why giving me N/A?

    I get 0 from the formula if G8 is #N/A, or if G8 is zero, or if AB8 is > zero. I thought it was funny you'd want 0 if G8 is not zero, but that's the formula you posted.
  14. Replies
    1
    Views
    93

    Re: Rotate histogram graph

    You can't rotate the histogram itself.

    You can copy it and paste it as a picture, then rotate the picture, but that won't be dynamic.

    You can copy the range of cells under the histogram, then...
  15. Replies
    3
    Views
    158

    Re: Looking to make custom Ribbon buttons

    For your specific requirement (a Center Across toggle), please see How To Add A Center Across Selection Button To Excel's Home Ribbon Tab. Excel MVP Chris Newman has written a small add-in that adds...
  16. Replies
    1
    Views
    39

    Re: Horizontal Bar Chart Question

    Make your data columns Project Name, Start Date, and Number of Days. Make a stacked bar chart.

    See my tutorial Gantt Charts in Microsoft Excel
  17. Replies
    5
    Views
    149

    Re: Maximum file sizes

    What kind of file? Have you inspected their contents?
  18. Replies
    3
    Views
    87

    Re: Graph Question with 2 X-axis

    You need three columns in this order:

    Date, Heart Rate, Perceived Effort

    Select the data, insert a line chart.

    Select the Perceived Effort series in the chart, press Ctrl+1 to format it, and...
  19. Replies
    1
    Views
    89

    Re: Working with minutes and seconds

    I don't really see a question in there, which is probably why nobody has tried to submit an answer.

    Note: a format of [mm].ss.00 will keep counting minutes, above 60 if the time is over an hour.
  20. Replies
    9
    Views
    259

    Re: Problem With Looping through Charts

    What is highlighted when you get the error? Maybe one of your charts does not have one of its axes.
  21. Replies
    11
    Views
    255

    Re: why giving me N/A?

    so

    =IF(OR(G8=0,ISNA(G8),AB8>=0),0,AB8)

    or

    =IF(OR(G8=0,G8=#N/A,AB8>=0),0,AB8)
  22. Re: Combo Chart displaying some XY scatter markers but not others

    No attachment...

    I've found that sometimes an XY scatter chart series added to a line or other chart can't plot more points than the underlying chart type contains.
  23. Re: make chart axis labels hyperlink to other pages

    I'd have to see the initial chart to know exactly how to help. I can't think of a way to hyperlink from the axis labels. But you could click on a point for that axis category and write some VBA to...
  24. Thread: line graph

    by Jon Peltier
    Replies
    2
    Views
    64

    Re: line graph

    Right click on the series of points, choose Format Series.

    In the Format Series Task Pane, click on the paint can icon.

    Click Markers, then select the size (and shape) you need.
  25. Replies
    5
    Views
    202

    Re: VBA Insert image into a cell

    A. I was going to say that you can always kill the image file after you insert it into Excel. Like what's the big deal.

    B. Your original code finds the image and download it to your computer, then...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4