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 » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Charts and Charting Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Scatterplot with background area plot by MikeM
I’m plotting (Excel 2007) monthly crime data from 1960-2007 (576 data points) for USA counties. The crime rate is the crime count divided by the...
September 6th, 2009 11:24 PM
by MikeM Go to last post
4 134
How can i see if two points share a coordiante in a scatter graph? by cmeakin
I've plotted a scatter graph but i know that some of the data repeats, i.e. there would be more than one point at a certain coordinate. How can i get excel to...
September 6th, 2009 07:11 PM
by cmeakin Go to last post
0 128
How to rename a GROUP in a Pivot table by spudsnruf
Hi, trying to rename a GROUP in a Pivot table. eg I have 3 groups which are for 3 yrs sales, 2007, 2008 and 2009. In the pivot table, they are just named...
September 5th, 2009 05:21 AM
by Shane Devenshire[_3_] Go to last post
2 470
'formula 1' appears in Pivot Table after grouping by spudsnruf
Hi, when I use 'Group Selection' inside a pivot table, the words 'formula 1' suddenly appear inside the data I am trying to group. and then if I am trying to...
September 5th, 2009 05:19 AM
by Shane Devenshire[_3_] Go to last post
1 141
Pivot chart: wrong date order on horizontal axis by spudsnruf
Hi, I have a pivot chart linked to a pivot table. The chart produces a bar graph for 2 sets of data, (product A and B) and each with its own vertical axis....
September 5th, 2009 05:15 AM
by Shane Devenshire[_3_] Go to last post
1 119
exclude certain data by Saintsman
Hi I have a series of data in rows which are plotted on a simple line chart. Sometimes I want to exclude a particular data row from appearing on the chart by...
September 5th, 2009 05:10 AM
by Shane Devenshire[_3_] Go to last post
1 114
Pivot Table Chart Legend by Chiccada
Hello all. I am currently developng a Line chart via a pivot table. One thing I have noticed is that the legend runs in ascending order. E.g. Z at the top...
September 5th, 2009 05:06 AM
by Shane Devenshire[_3_] Go to last post
2 123
Rotate / Change axis of chart? by Dave452
Help is needed! I have a simple chart colum A are Dates and C is tempature; Using 2003's wiszard it created a chart with temps on the Left and Dates on/at...
September 5th, 2009 03:43 AM
by Dave452 Go to last post
2 144
AppsPro XY Chart Labeler functionality by LFNFan
Hi Does anyone know if the AppsPro XY Chart Labeler is able to dynamically update data point labels on a chart if the data in the 'label' cells changes? I...
September 4th, 2009 02:14 PM
by Robert Flanagan Go to last post
5 153
DOT Chart by Rob
I have created a line chart using Jon Peltier's DOT chart example http://peltiertech.com/Excel/Charts/DotPlot.html i.e. rotated my chart so the labels go up...
September 4th, 2009 09:32 AM
by Rob Go to last post
2 99
Shading in Chart by Chris
I have a column chart with the axis from +30% to -30%. I want to highlight the columns that fall outside of the 5% range. Is there a way to shade the plot...
September 4th, 2009 09:16 AM
by Andy Pope Go to last post
1 141
percentile markers or boxplot on excel scatter graph by Saroj
Hi everyone, I am trying to create percentile markers next to each group on a scatter graph. The percentile markers are 5th, 25th, 50th, 75th and 95th. The...
September 4th, 2009 02:48 AM
by Jon Peltier[_2_] Go to last post
1 193
Remove time portion from date on Excel 2007 chart by NeoFax
I am trying to remove the auto generated time of 00:00 to every date in my chart. I have tried setting the format, but it just ignores whatever I try to...
September 4th, 2009 02:43 AM
by Jon Peltier[_2_] Go to last post
1 145
plotting line charts with formula based 'gaps' by mick perry
I am trying to visually represent different conditions on a line chart (e.g. underlying data is rainfall in the UK; plot as a dashed line. The conditions...
(Multi-page thread 1 2)
September 4th, 2009 02:32 AM
by Jon Peltier[_2_] Go to last post
11 191
4 graphs / one sheet / cramming for space by ORLANDO VAZQUEZ[_2_]
Hi, I have four pie charts that are displayed on one 8.5" x 11" worksheet. I am having a difficult time resizing so that that all play nice on the same...
September 4th, 2009 02:30 AM
by Jon Peltier[_2_] Go to last post
3 138
Data Validation to range names for Chart Source Data by Candyman
I have 15 Named Ranges. I'd like to have a drop down above one chart to select one of the names and the chart updates. How? Please help
September 3rd, 2009 07:27 PM
by tpeter Go to last post
1 119
Changing the date format on the date table in a chart by spudsnruf
Hi, I have a data table under a chart, and the dates inside the table are in the format of dd/mm/yyyy but I need to change them to dd/mm/yy. I cant see how...
September 3rd, 2009 07:08 PM
by spudsnruf Go to last post
2 115
Cannot choose "series name" for label by FrugalYankee
Excel in Office XP offered the choice of "Series Name" "Category Name" or "Value" in the "Format Data Series" popup. Now I have Office 2007 and it seems that...
September 3rd, 2009 07:01 PM
by FrugalYankee Go to last post
4 141
How to include totals in charts based on pivottables? by Arne Olsson
Hi! I often make charts based on pivottables. In some cases i would like to include totals from the pivottable in the chart but i dont know how to do this....
September 3rd, 2009 01:53 PM
by Arne Olsson Go to last post
1 122
Total of Stacked Column Chart by Karen
Using 2003 I have a stacked column chart with 10 different stacks/series of data. I want to show the total of all the stacks at the top of each column. What I...
September 3rd, 2009 08:50 AM
by Andy Pope Go to last post
1 140
Post New Thread

Display Options
Showing threads 1081 to 1100 of 15904
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 05:46 AM.

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