I have about 30000 lines of data that looks like so:
Where ColA is time. I am having trouble creating a graph with time on the
x-axis and count on the y-axis.
Thank you in advance.
You need to make an XY chart
But with 30,000 data points you could run into trouble; Help says you can
32,000 data points in a single data series.
However, if you want markers it will look like heck.
You could limit the data like this:
assume y-values in B2:B30001
in ...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...referencing lines and series points
what is the VBA code for referencing to individual points in a line on
line graph? i would like to create a macro to change indiviual points
shapes and the color or the lines in between them to different color
depending on different parameters. is this possible
medicenpringles's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1645
View this thread: http://www.excelforum.com/showthread.php?threadid=39101
Ther easiest way to do this is to first record a macro doing what y...Chart Linking
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Updating a workbook from many workbooks.
I am using excel 2003. I have a report workbook that has 27 other workbooks
that it gets information from. What is the easiest way to update the report
workbook with out me singularily opening each of the 27 other work books.
The are all under the same folder on the same drive. including the report
You have not said what you want to do when all of the books are open.
The following code opens all 27 workbooks for you. If you could post
more information we might be able to get you a more specific result.
Change the file path to suit.
Mar...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...combination clustered column and stacked bar chart
I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.
I don't know if I'm fully understanding what you want. Possibly these two
examples can hel...Error in chart wizard
The following error occured in Excel 97:
-> User clicked on chart wizard
-> clicked the customer types tab and got the following
errors one after the other:
1st - Microsoft Visual Basic Permission to use object
2nd - Microsoft Excel Error accessing user-defined custom
3rd - Program error Excel.exe has generated errors and
will be closed by windows. You will need to restart the
program. An error log is being created.
This happened on more than one machine. I do not get this
error message on my machine. I have a screenshot of the
errors if it would help.
Anyone else had problems with Excel 2007 corrupting workbooks when
using the Analysis Toolpak. All formulae requiring the toolpak are
replaced with #N/A (ie XIRR, EDATE).
Man, this sucks.
Congratulations MS on releasing a "Professional" version of your
software that is so much less easy to use than the old version.
Charts look nice (although with some of the most useful features
removed), but the menus SUCK. Hide the ribbon and use keyboard
shortcuts and you might as well use the mouse because the ribbon has
to be displayed each time you use the keyboard shortcuts.
Excel 2007 su...Chart of Accounts #4
We're looking to move to GP and currently have a 1 segment chart of account -
we would like to change to a multi-segemtn chart. Can anyone point me to some
documentation on ideas of how to set our chart up.
I've done many chart of accounts setups over the years. The format I
like is a 3 segment account number where the first segment is the
"division", the second segment is the "main" account, and the third
segment is the "department". Even if you don't need the "division"
segment now, you may in the future.
This format...xy scatter
In Excel 2003 if I highlight three columns of data and create an xy
scatter graph, it assumes the first column are the x values and the
second two columns are two y series. I like this. I'm now having to
adapt to 2007 (I run a science lab at a college). In 2007, when I do
the same thing, it gives me a line graph with three series, even
though I chose an xy scatter graph. Is there a way I can make it act
like 2003 used to?
...Creating A Stack & Line Combo Chart
Is it possible to create a stack chart with 4 series
stacked, and a 5th series being a line. If so how do I do
it. Thanks very much
1. Create a stacked column chart from all the data
2. Select the series that you want as a line
3. Choose Chart>Chart Type, and choose the Line
chart type, and one of the subtypes
4. Click OK
Ty Archer wrote:
> Is it possible to create a stack chart with 4 series
> stacked, and a 5th series being a line. If so how do I do
> it. Thanks very much
Excel FAQ, Tips & Book List
...Missing Data Options
I am trying to use Tools - Options - Chart. I want to use the "not
Plotted" option. When I click on it my chart does not change. This
happens after I've selected the chart and then trying to make these
What am I doing wrong?
I want to create a chart that ignores missing data, and gives me a
trend line based on the data I have.
I've had my nose in my Excel "bible" but can't find the answer.
I greatly appreciate any tips.
jimsmith888's Profile: http...Extracting data and returing to colums.
I am about half way there, but I need some more help.
These are web inquires that parsed out in the same colum and repeat th
same way all down the page.
I want to be able to use the fields as guidelines to pull the dat
adjacent to it and sent to the new colum. In a way it is transposin
all the data, but I need to pull all the first names of these peopl
and have them align in the first colum. Same for Last name, business
So if the information that I have come across like this in th
spreadsheet, I just want the customer infomation to move to th
appropriate colums like the third example...