|
Related Topics:
| Axis labels truncated in Excel 2004 Mac - Hello, I'm having issues with category axis labels or being cut off if they get too long in Excel. This happens on both bar and column graphs. Usually I'm able to get them all to show up by rotating them or by the in the..
Charts in Excel Mac 2008 - Crashes with 'large' datasets - Hi, Excel Mac 2004 used to be able to plot 32,000 data point graphs without 2008 becomes at around 3,000 (loud vacuum cleaner sound from MacBook C2D with 2 gigs RAM). Anyone else having similar problems? Happens with XY or..
Getting Axis Labels to Fit - How can I get my axis labels to fit so that all of the label is showing? I've got a 3D column chart showing regions of the world on the x axis. But only shows and only shows I've reduced font size to 8,..
vertical alignment of axis tick labels - Hi, I'm new to Excel for macs, and have a question. I'm using Mac OS X 10.4.3 and Excel 2004 for Mac, version 11.2. My problem is that I have created a xy scatter chart with dates on the x-axis, but I can't change the alignment of the dates from..
Doing the right thing for missing data and area charts - Hello, I'm a dashboard report for a client that uses area charts. we have to deal with missing data. For other chart types, Excel can be made to do the right thing, but for area charts, I don't seem to be able to have the chart..
|
|
|
Next: Excel: Default new workbook, can't get rid of sheets
|
| Author |
Message |
External
Since: Jan 25, 2008
Posts: 1
|
(Msg. 1) Posted: Fri Jan 25, 2008 11:28 am
Post subject: area charts in excel 2008 - how to add x-axis labels?
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
Hi, I'm having a simple problem with area charts in excel 2008.
I have some simple data that I want to make into an area plot:
population on the y-axis, year on the x-axis.
In excel for windows (excel 2003), when I make this plot, I'm asked to
fill out the following fields: Name, Values, x-axis labels.
Everything's fine.
When I try and make the same plot in excel 2008 for mac, I can't add
my x-axis labels. I'm presented with a window that asks for: chart
data range, Name, Y values.
The result is that the x-axis just goes from 1-10 if I have 10 data
points instead of the year (which is what I want).
How do I actually enter my x-axis data? Am I overlooking something
here? |
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 2) Posted: Thu Jan 31, 2008 8:09 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article
<0bf3bb22-eebc-4c23-b8c5-ba3c0fe1212a.RemoveThis@c23g2000hsa.googlegroups.com>,
Ben <bkenney.RemoveThis@gmail.com> wrote:
> How do I actually enter my x-axis data? Am I overlooking something
> here?
Nope. It's a bug.
Workaround:
Create your chart first as an XY-scatter chart. Then switch to an Area
chart using the Chart Gallery. |
|
| Back to top |
|
| |
External
Since: Jan 15, 2008
Posts: 66
|
(Msg. 3) Posted: Thu Jan 31, 2008 11:56 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 02, 2008
Posts: 1
|
(Msg. 4) Posted: Sat Feb 02, 2008 3:31 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Jan 31, 2:56 pm, <> wrote:
> If you hold down the command key and highlight the column that has the dates and then highlight the columns that have the date you want. That should work. Try it
I'm having the same problem and i don't understand the solution from
the post so far. How can you add a label to your x-axis? >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 5) Posted: Sun Feb 03, 2008 5:46 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article
<efaffc55-2ce2-4070-902a-1880d7986fb1.DeleteThis@s12g2000prg.googlegroups.com>,
dharbes.DeleteThis@gmail.com wrote:
> I'm having the same problem and i don't understand the solution from
> the post so far. How can you add a label to your x-axis?
One way:
Switch to an XY-Scatter chart and add the labels, Switch back to Area. >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Feb 11, 2008
Posts: 1
|
(Msg. 6) Posted: Mon Feb 11, 2008 9:21 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 20, 2008
Posts: 1
|
(Msg. 7) Posted: Wed Feb 20, 2008 7:27 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Feb 12, 7:37 am, Bob Greenblatt <b... DeleteThis @nospam.com> wrote:
> On 2/12/08 12:21 AM, in article ee8a82... DeleteThis @webcrossing.caR9absDaxw, "carl."
>
> <carl.> wrote:
> > Well this is a bug, there is no reason you shouldn't be able to set the x-axis
> > values in all chart types.
>
> > And sorry Bob, but creating a text box to assign x-axis values is just wrong.
>
> Carl, You CAN add X axis labels. Just select the chart and go to the
> formatting palette. Select chart options and then titles, and then chose X
> Axis.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
Bob,
Thanks for clearing up how to do this.
I do think it was a poor move (not to say stupid) on Microsoft's part
to get rid of the possibility of right-clicking on the chart and going
to chart options.
They could just have the right click open the formatting palette... >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Feb 27, 2008
Posts: 1
|
(Msg. 8) Posted: Wed Feb 27, 2008 11:07 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In case others are confused by Bobs unclear and slightly conflicting replies and the hopeless Office help.
To add axis labels you need the formatting palette, to get this you need to click on the button marked toolbox and on the window that opens you need to select the leftmost icon from the row of icons at the top.
Once you have the formatting palette click on your chart and then open the chart options section and there should be a drop down menu which initially says "Chart title". Click here to access and edit your axis labels. >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 04, 2008
Posts: 2
|
(Msg. 9) Posted: Tue Mar 04, 2008 11:44 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Feb 27, 9:07 pm, JonM <> wrote:
> In case others are confused by Bobs unclear and slightly conflicting replies and the hopeless Office help.
>
> To add axis labels you need the formatting palette, to get this you need to click on the button marked toolbox and on the window that opens you need to select the leftmost icon from the row of icons at the top.
>
> Once you have the formatting palette click on your chart and then open the chart options section and there should be a drop down menu which initially says "Chart title". Click here to access and edit your axis labels.
Now you can add a text to that axis, but there's still no way to add
those dates Ben is looking for. Still waiting for an answer... >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 04, 2008
Posts: 2
|
(Msg. 10) Posted: Tue Mar 04, 2008 11:51 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Feb 27, 9:07 pm, JonM <> wrote:
> In case others are confused by Bobs unclear and slightly conflicting replies and the hopeless Office help.
>
> To add axis labels you need the formatting palette, to get this you need to click on the button marked toolbox and on the window that opens you need to select the leftmost icon from the row of icons at the top.
>
> Once you have the formatting palette click on your chart and then open the chart options section and there should be a drop down menu which initially says "Chart title". Click here to access and edit your axis labels.
Actually found the solution at
http://www.mackb.com/Uwe/Forum.aspx/excel/4535/Cannot-add-data-as-labe...for-the
Click on the data series you want to add labels for. A formula like
this "=SERIES(,,Sheet1!$Q$20:$Q$25,1)" should appear. Go between the
second and third comma and select the range with your labels. Thank
you, Microsoft! >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 29, 2008
Posts: 1
|
(Msg. 11) Posted: Sat Mar 29, 2008 2:23 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> In article
> ,
> Ben wrote:
>
> Nope. It's a bug.
>
> Workaround:
>
> Create your chart first as an XY-scatter chart. Then switch to an Area
> chart using the Chart Gallery.
Yep, it *is* a bug. Fortunately, I can plot my data as a scatter chart. However, when I switch to line, which is what I have always used, the bug reappears in the X axis.
> >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 29, 2008
Posts: 1
|
(Msg. 12) Posted: Sat Mar 29, 2008 2:26 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 22, 2004
Posts: 526
|
(Msg. 13) Posted: Sun Mar 30, 2008 11:35 am
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee8a82e.14 DeleteThis @webcrossing.caR9absDaxw>,
Aurens DeleteThis @officeformac.com wrote:
> While I'm at it, this is hardly a minor bug, and this release has been around
> for a while now. Trying to figure out how to make charts has been a headache
> for months. Is there a list of known bug somewhere? There should be!
Well, some of us consider trying to use Excel to make charts a terrible
mistake in the first place :-( .
Trouble is, it takes some training to learn something good like GnuPlot.
--
Team EM to the rescue! http://www.team-em.com >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Apr 12, 2008
Posts: 1
|
(Msg. 14) Posted: Sat Apr 12, 2008 3:17 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Mar 4, 8:51 pm, andres.k....DeleteThis@gmail.com wrote:
> On Feb 27, 9:07 pm, JonM <> wrote:
>
> > In case others are confused by Bobs unclear and slightly conflicting replies and the hopeless Office help.
>
> > To add axis labels you need the formatting palette, to get this you need to click on the button marked toolbox and on the window that opens you need to select the leftmost icon from the row of icons at the top.
>
> > Once you have the formatting palette click on your chart and then open the chart options section and there should be a drop down menu which initially says "Chart title". Click here to access and edit your axis labels.
>
> Actually found the solution athttp://www.mackb.com/Uwe/Forum.aspx/excel/4535/Cannot-add-data-as-lab....
> Click on the data series you want to add labels for. A formula like
> this "=SERIES(,,Sheet1!$Q$20:$Q$25,1)" should appear. Go between the
> second and third comma and select the range with your labels. Thank
> you, Microsoft!
This worked, but didn't give me a quite the graph I wanted. It's been
a while since I made a graph in Excel, but my data for the x-axis is
units sold, and it's not always the same interval (the chart is break-
even data).
My Units Sold data goes 0, 10, 20, etc.. in intervals of ten, until
100, 120, 140, 160. This gives me a steeper curve after 100, which
I'm sure did not used to happen in earlier versions of Excel, as it
creates an awfully confusing graph.
The scale section of the x-axis format window doesn't offer any help
at all on making my graph look right.
-J >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
External
Since: Mar 22, 2004
Posts: 526
|
(Msg. 15) Posted: Sun Apr 13, 2008 12:28 pm
Post subject: Re: area charts in excel 2008 - how to add x-axis labels? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article
<85610ebf-01d4-4e8e-8f5e-15170c64ca6d.TakeThisOut@n1g2000prb.googlegroups.com>,
just.call.me.jesus.TakeThisOut@gmail.com wrote:
> > Actually found the solution
> > athttp://www.mackb.com/Uwe/Forum.aspx/excel/4535/Cannot-add-data-as-lab....
> > Click on the data series you want to add labels for. A formula like
> > this "=SERIES(,,Sheet1!$Q$20:$Q$25,1)" should appear. Go between the
> > second and third comma and select the range with your labels. Thank
> > you, Microsoft!
>
> This worked, but didn't give me a quite the graph I wanted. It's been
> a while since I made a graph in Excel, but my data for the x-axis is
> units sold, and it's not always the same interval (the chart is break-
> even data).
>
> My Units Sold data goes 0, 10, 20, etc.. in intervals of ten, until
> 100, 120, 140, 160. This gives me a steeper curve after 100, which
> I'm sure did not used to happen in earlier versions of Excel, as it
> creates an awfully confusing graph.
>
> The scale section of the x-axis format window doesn't offer any help
> at all on making my graph look right.
>
> -J
You need to select ScatterPlot as the chart type.
--
Team EM to the rescue! http://www.team-em.com >> Stay informed about: area charts in excel 2008 - how to add x-axis labels? |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
