Help with 2007 Chart Layout1682 (11/11/2009 3:28:29 AM) UtfHi,
I can't figure out how to build the chart I'm hoping to create.
I have data by: quarters, regions, $ and #.
Q1 Americas $100 5
Q2 Americas $200 7
Q3 Americas $120 3
Q1 Asia $213 4
Q2 Asia $3...
Radar chart with Area and Lines1772 (11/13/2009 2:22:01 PM) UtfHow can I make a radar chart that shows the area filled in to plot "actual
numbers" and use lines to plot "goal numbers".
I want series 1 to show as the area filled and my series 2 to show as lines
in a r...
Balance Points in Excel Charts11892 (11/13/2009 9:30:01 AM) UtfHi.
I regularly produce stacked bar charts to show ranges of opinions (e.g. very
poor, poor, acceptable, good and very good quality).
In these charts I often manually add a drawing shape to show a 'ba...
Excel 2007 option4714 (11/12/2009 3:33:01 AM) UtfThe display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?
How do I disable automatic chart creation in Excel?11301 (11/12/2009 10:54:01 PM) UtfWhen using the insert chart buttons, specifically XY scatter, Excel
automatically plots my entire dataset. I do not want this to happen with
large datasets b/c I need to manually delete all the entires. I...
Switch x and y axes31677 (11/12/2009 1:06:02 AM) UtfI have a line chart that has the x and y data on the opposite axes to what I
need. I can't figure out how to get my data to chart correctly. The data is
basically as follows and I need height on the y axis ...
Pie Chart with automatic "All Other" group11042 (11/12/2009 8:35:58 PM) DataHi there,
I have a long list of "accounts" that have a dollar value next to them. I
would like to get the top accounts by dollar to show up individually in a pie
chart but have a group encompassing the rem...
Chart Disappears01215 (11/12/2009 2:43:02 PM) UtfI have recently been using a new installation of Microsoft Excel 2007, which
is up to date with updates/patches/service packs. Anytime I create a chart
within a sheet, next to the data, I have no issues se...
copying chart to location within same workbook2708 (11/11/2009 3:31:27 AM) UtfI have created a chart that I wish to use as a template for many other charts
in the same workbook. I copy it by right-clicking on the tab, ‘name of chart'
sheet, select ‘move or copy’, tick the ‘create a c...
Excel Chart Lines0708 (11/11/2009 11:03:50 PM) MI had 2003 and recenlty upgraded to 2007. I have a chart that the lines on the Y axis are all scrunched together to practicly make 1 bar instead of the 4 that should be see. I think it's possibly formatting......
How do I write text on a bar chart using VBA11020 (11/11/2009 4:59:03 PM) UtfI have a worksheet with various bar charts. I want to write text inside the
bar but cannot figure out the correct control name to modify the text. Any
help is appreciated
Can you tile 8 charts on a worksheet?11681 (11/11/2009 4:26:19 PM) UtfIs this possible in excel. I am familiar with the distribute and align
functions, but I am wondering if there is a simple way to select all charts
and have them move into 2 colums on the page?
Any help w...
Excel drawing --> html/css?0615 (11/11/2009 4:36:01 PM) UtfI have a fairly complicated excel illustration (drawn using autoshapes
elements) that I'd like to be converted to html/css. Goal is to have the
attributes of selected graphical elements (color, embedded tex...
Axis labeling1609 (11/10/2009 6:02:02 PM) UtfWe have created a chart showing daily load for a given month. The bottom
axis shows the days in the month (1-31). When we open the chart on one
computer, all 31 labels show, which is what we want. When w...
Map module in Excel4891 (11/6/2009 1:36:01 PM) UtfAn earlier version of Excel had a world mapping module? Does anyone remember
2003 Excel Chart with zero data51061 (11/10/2009 4:30:01 PM) UtfI have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a...
the date value of series is incorrectly displayed0660 (11/10/2009 5:46:06 PM) UtfI'm drawing a 3d graph with 2 series of data. The graph is displayed as 2
separate rows of bars behind each other. In Excel 2007 the type is Colum in
the first row to the far right.
1. series is a un...