Chart moves on plot area when adding a third month
Fri, 12 Mar 2010 10:06:11 -0800
I am working on an area chart that I update weekly. It's a very simple
chart. The data looks like this:
Month Count
Jan-10 401
Feb-10 435
Mar-10 450
Currently the chart is only using Jan-Feb data. I'm trying to add March to
the scale however every time I do the graph condenses and then reloc ...
|
Chart Formatting
Fri, 12 Mar 2010 08:46:01 -0800
Is it possible to change the color of a bar chart depending on the value of a
cell?
I want the bar graph to show 2 colors BUT would like for the colors on the
Provider bar to show Green above the 60% and show Red below 60%.
Member's bar to show Green above 80% and show Red below 80%. ...
|
How do I get my sizing handles back? Graph/data on same page.
Thu, 11 Mar 2010 15:30:01 -0800
I created a simple line graph on the same page as the data. The blue sizing
handles use to be present when I wanted to add data, but now the handles are
no longer present and I have to go through the longer way of adding data by
using the Chart source data option. Is there a way to get the sizing handles
b ...
|
Scatterpoot not using X values properly -- using relative ranking
Thu, 11 Mar 2010 09:45:01 -0800
I have created a scatterplot where the X value is to be one value (risk) and
the Y value is to be another (return). I've entered the X and Y value ranges
properly and the y value is being plotted correctly, BUT the X value is not
being plotted as the correct X value. Instead, the X value is being
interpret ...
|
Change order of items in a legend
Thu, 11 Mar 2010 07:54:01 -0800
Hello, how do I change the order of items that appear in a legend.
I have a legend below a chart that displays:
x = red y = blue z = yellow and I would like to display
z = yellow x = red y = blue
Thanks in advance ...
|
How do I change the color of the timeline boxes in my Ghant chart
Thu, 11 Mar 2010 07:34:06 -0800
My ghant chart automatically boxes out my time line when I input my start and
end dates for each activity. How can I change the color of the time line? I
want to make different activitites different colors. ...
|
pie chart not visible
Wed, 10 Mar 2010 20:15:01 -0800
I have some data I want to show in a pie chart but when I do so the graph
area comes up with its legend but I don't see the pie chart itself. I have
tried formatting the chart settings but to no avail, help?! ...
|
|
|
Excel 2007 - publish chart as htm web page file
Wed, 10 Mar 2010 19:05:01 -0800
When I select a chart in Excel 7 and select Save As, I can choose file type
Web Page (.htm file) just like in 2003, but it no longer gives the option to
select just the chart. How do you save just the chart as a web page rather
than the whole sheet or whole file?
This was a simple processs in Excel 2003:
...
|
How do I extend the X-axis in Excel2007
Wed, 10 Mar 2010 14:42:02 -0800
I have a line graph of accounts on the Y-axis, plotted against months on the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it again
for 2010, but I am having trouble. ...
|
how to copy sheet with charts without link to original data
Wed, 10 Mar 2010 11:15:01 -0800
I have a worksheet with ten charts on it. I need to copy the worksheet with
all its data and related charts to new sheets or files so I have a page for
every day, with different data entered every day. But when I copy the
worksheet with embedded charts and paste it into a new file, the charts pull
their sour ...
|
