A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.78 seconds.
Search: Posts made by: Jon Peltier[_2_]
Forum: Charts and Charting June 5th, 2010, 08:12 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 2,049
Posted By Jon Peltier[_2_]
How do I insert a hyperlink into a chart element?

It's not so easy. You need to set up code to recognize chart events,
then respond to the specific event. This article described chart events
in Excel charts:

Chart Events in Microsoft...
Forum: Charts and Charting June 3rd, 2010, 03:25 AM Posted to microsoft.public.excel.charting
Replies: 3
Views: 2,080
Posted By Jon Peltier[_2_]
Show zero value but hide NA

The NA() trick only is relevant to line or XY charts. In a bar chart use
0, since a zero-height bar isn't visible. Your custom number format will
work just fine.

- Jon
-------
Jon Peltier
Peltier...
Forum: General Discussion June 1st, 2010, 06:14 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 238
Posted By Jon Peltier[_2_]
How can I put a text box in every cell?

Can't you just use cells to contain the text?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/31/2010 5:08 PM, bmowell wrote:
Forum: General Discussion June 1st, 2010, 06:13 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 950
Posted By Jon Peltier[_2_]
The last day

Technically correct. The newsgroups will continue to exist on other news
servers. But the newsgroups have been in decline for some time, at least
in terms of posting volume. I think we'll see the...
Forum: Worksheet Functions June 1st, 2010, 06:13 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 704
Posted By Jon Peltier[_2_]
The last day

Technically correct. The newsgroups will continue to exist on other news
servers. But the newsgroups have been in decline for some time, at least
in terms of posting volume. I think we'll see the...
Forum: New Users June 1st, 2010, 06:13 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 4,416
Posted By Jon Peltier[_2_]
The last day

Technically correct. The newsgroups will continue to exist on other news
servers. But the newsgroups have been in decline for some time, at least
in terms of posting volume. I think we'll see the...
Forum: General Discussion May 31st, 2010, 07:11 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 302
Posted By Jon Peltier[_2_]
Excel 2007 - Copy Picture Resolution

I have been extremely dissatisfied with the picture format in Excel
2007. In earlier versions it was decent but in 2007 it's horrible. In
2007 bitmaps look better than the metafile (picture)...
Forum: General Discussion May 28th, 2010, 07:18 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 290
Posted By Jon Peltier[_2_]
Parallel Box Plots

What's a "parallel" box plot?

Box and Whisker Charts in Excel:
http://peltiertech.com/Excel/Charts/BoxWhisker.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Forum: General Discussion May 28th, 2010, 07:16 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 176
Posted By Jon Peltier[_2_]
Can't drag new data to chart in 2007.

They removed this functionality from Excel 2007.

Copy the cells you want to include, select the chart, and paste.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Forum: General Discussion May 28th, 2010, 07:14 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 118
Posted By Jon Peltier[_2_]
Zero's plotted in charts?

The numbers may have been entered as text, even if the cells are now
formatted as numbers. You can tell by clicking the Add Decimal button.
If no decimal digit is added, it's text.

To fix, select...
Forum: General Discussion May 26th, 2010, 06:19 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 522
Posted By Jon Peltier[_2_]
Office Professional Xp user buys a Mac

Also, Office 2004 (Mac) uses an older generation of VBA than Office 2000
and later (Windows), so you may run into incompatibilities with code.

- Jon
-------
Jon Peltier
Peltier Technical Services,...
Forum: Charts and Charting May 24th, 2010, 07:19 PM Posted to microsoft.public.excel.charting
Replies: 2
Views: 345
Posted By Jon Peltier[_2_]
How do I display data in a bar charted rounded to thousands?

If you don't want to change the values, but only the display, select and
right-click the data, choose format, then click on Number, and choose a
number tab like one of these

0,
0,k

The comma...
Forum: General Discussion May 21st, 2010, 04:23 AM Posted to microsoft.public.excel.misc
Replies: 4
Views: 109
Posted By Jon Peltier[_2_]
Select Specific Data From Cells For A Chart

Don't try to be clever and use the original range in the chart. You're
going to have to use a nearby range to hold the values to be plotted.
Use whatever function you need in this range to extract...
Forum: General Discussion May 21st, 2010, 04:19 AM Posted to microsoft.public.excel.misc
Replies: 4
Views: 247
Posted By Jon Peltier[_2_]
Veritical & Horizontal Lines only ... Graph?

Sounds like you want a variation of a step chart:

Line Chart vs. Step Chart » Peltier Tech Blog
http://peltiertech.com/WordPress/line-chart-vs-step-chart/

- Jon
-------
Jon Peltier
Peltier...
Forum: Charts and Charting May 21st, 2010, 04:15 AM Posted to microsoft.public.excel.charting
Replies: 4
Views: 1,403
Posted By Jon Peltier[_2_]
Get 2007 Chart to fill page

Nope, you can't size the chart to fit the window in 2010. It might be
nicer in the way it fits the chart into the print area, but it still
does not fit the chart to the window.

Too bad, it would...
Forum: Charts and Charting May 21st, 2010, 04:09 AM Posted to microsoft.public.excel.charting
Replies: 2
Views: 396
Posted By Jon Peltier[_2_]
Trendline partial data

You need to add a series that contains only the data you want included
in the trendline.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Forum: Charts and Charting May 21st, 2010, 04:07 AM Posted to microsoft.public.excel.charting
Replies: 3
Views: 444
Posted By Jon Peltier[_2_]
Excel 2007 - problems with macro to change series formula

FChgSrsFmla is the user form used to get user input.

It would probably be easier to distribute the whole add-in to anyone who
needs the functionality.

- Jon
-------
Jon Peltier
Peltier Technical...
Forum: Charts and Charting May 18th, 2010, 05:57 PM Posted to microsoft.public.excel.charting
Replies: 3
Views: 444
Posted By Jon Peltier[_2_]
Excel 2007 - problems with macro to change series formula

I've provided a link to an updated add-in to handle this change in a
recent article:

How to Edit Series Formulas
http://peltiertech.com/WordPress/how-to-edit-series-formulas/

If you need to put...
Forum: Charts and Charting May 18th, 2010, 05:53 PM Posted to microsoft.public.excel.charting
Replies: 4
Views: 1,403
Posted By Jon Peltier[_2_]
Get 2007 Chart to fill page

You are missing nothing. Excel 2007 is missing this capability, which
Microsoft removed for some unknown reason.

You would have to manually stretch the chart to fit on a single page.

-...
Forum: Charts and Charting May 15th, 2010, 03:12 AM Posted to microsoft.public.excel.charting
Replies: 1
Views: 431
Posted By Jon Peltier[_2_]
Pyramid Charts

Can't you just use a bar chart? People will tend to focus on the fancy
shape, and wonder how you made it, and forget the data it's supposedly
showing.

- Jon
-------
Jon Peltier
Peltier Technical...
Forum: Charts and Charting May 15th, 2010, 03:10 AM Posted to microsoft.public.excel.charting
Replies: 4
Views: 414
Posted By Jon Peltier[_2_]
Is it possible to resize chart itself (not chart area)

Click inside the plot area, the rectangular region defined by the axes.
The rectangle should be highlighted with resizing handles on the corners
and edges. Click and drag these edges to stretch the...
Forum: Charts and Charting May 13th, 2010, 12:43 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 425
Posted By Jon Peltier[_2_]
Including Totals in Chart's data table

The data table only shows data in the chart. You can add the totals to
the chart, which puts them into the table, and then format the totals
series so it doesn't appear (no lines, markers, borders,...
Forum: General Discussion May 12th, 2010, 03:03 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 250
Posted By Jon Peltier[_2_]
how to draw fibonacci numbers

How do you want the drawing to look?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/12/2010 8:37 AM, spgokak wrote:
Forum: General Discussion May 12th, 2010, 03:02 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 139
Posted By Jon Peltier[_2_]
How to scale down my charts?

Select the chart (the chart area) and resize it by dragging the corners
or edges.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Forum: Charts and Charting May 12th, 2010, 02:58 PM Posted to microsoft.public.excel.charting
Replies: 2
Views: 334
Posted By Jon Peltier[_2_]
Trendline when data points are missing

What is your category axis (X values)? If it's not numerical, you do not
want a trendline.

Why can't you use a line with markers style to connect the points?

Your data should be in this...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 07:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.