Bar Graphs, Semi-Log Graphs



  • 1. How to apply different color on different columns and legends easily?
    Hi there I am creating a Column chart, with x-axis showing years (e.g. 1990 to 1999), and y-axis showing GDP. But i want to apply two different color on the columns (e.g. 1990 to 1995 use red colour columns, 1996 to 1999 use green colour columns) Questions 1) Is there an easy and automatic way to apply different color on the columns? (Prefer not to click each bar or click each to format data point) (Am using Excel 2003 version) 2) Can I add legend of my choice? How can i add 2 legends? For example, I want to add a red legend for year 1990 to 1995, the other green for year 1996 to 1999. Thanks for your help. cheers:)
  • 2. Timelines in excel
    I'm want to create timelines similar to those in MSProject in an excel chart. Is this possible and if so, how do I do it. Your help in this regard would be very much appreciated.
  • 3. How do I graph a polar equation in Excel?
    I'm trying to do some polar equations in Excel, and I'm not sure on how, or if I can do it. Help please?
  • 4. Chart a time series
    I'm sure this question has been asked a thousand times... How do I chart a time series (a series of dates with a value associated with each date)? The dates are not evenly spaced, and I would like the axis to be labeled with each actual date, rather than a series of evenly spaced dates not associated with the data? I've created a chart that does what I want, but the X axis shows a series of evenly spaced dates, not the actual dates for each data point. Under Chart Options / Axes / Value (X) Axis, I see Automatic/Category/Time Scale radio buttons. I suspect Time Scale might be what I want, but the radio buttons are grayed out. Thanks for any help.

Bar Graphs, Semi-Log Graphs

Postby Albert A. Bartlett » Fri, 01 Aug 2003 22:33:15 GMT

Dear Friends,

I have the Millennium 2000 edition of Excel and I can't 
figure out how to make
a) bar graphs of one variable vs. time. (all the options 
seem to be for two variables.)
b) semi-logarithmic graphs.

With my previous computer I had the Excel that went with 
Windows 95, and the Chart Wizard had options you could 
check for either one variable bar graphs or for semi-log 
graphs.  In the Millennium 2000 I don't find either of 
these options with the Chart Wizard.

Question No. 1:  At the bookstore I see an expensive 
upgrade I can purchase to upgrade Millennium to Windows 
XP.  Does this upgrade have the charting capabilities at 
least as good as those of Windows 95, or are they degraded 
to the level of those in Millennium 2000?

Question No. 2:  Why would Microsoft degrade a very useful 
Chart Wizard in Windows 95 to the much less useful one of 
Millennium 2000?

With thanks and best wishes, I am,


Albert A. Bartlett
Professor Emeritus of Physics
University of Colorado at Boulder, 80309-0390

Re: Bar Graphs, Semi-Log Graphs

Postby Tushar Mehta » Sat, 02 Aug 2003 00:36:31 GMT

This followup was posted to microsoft.public.excel.charting with an
email copy to Albert A. Bartlett.
Please use the newsgroup for further discussion.]

First, let's address the operating system vs. Excel issue. Most
likely, XL was loaded on your computer at the time you purchased the
computer. However, there is no relation between XL (or any other
Office product -- Word, PowerPoint, Access, etc.) and the operating
system (Win 98, Win ME, Win XP) etc. It is indeed unfortunate that MS
has a tendency of choosing product names and version ids that confuse

OK, so you don't need to upgrade Win ME to Win XP if you want to use a
different version of XL (XL97, XL2000, XL2002, etc.) However, you
don't need to change your version of XL either.

Whatever version of XL you have on your computer (my guess would be XL
2000) is quite capable of doing what you want to do. MS hasn't changed
XL's charting module in any significant manner for a long, long time.
The differences you see between the previous computer and the new one
are probably due to minor tweaks made by MS but also because of your
computer's configuration (templates, default charts, user defined
charts, etc.)

On to your specific requests: I don't know what you mean by a one-
variable bar graph vs. time, but I suppose it consists of x-values
representing time and y-values representing whatever it is you wish to
plot. If so, it will help a lot if there is an empty cell at the top
of the date values but not on top of the data values. Something like:

2 Price
3 1-Jan 1
4 2-Jan 1.045

Select the two columns that contain the dates and the variable values
and include the top row (row 2 in the example above). In the Chart
Wizard, select the Bar (or Column?) chart. In the next step, ensure
that XL plots the first column as x-values.

If you have date-time values that represent a finer division of a day,
XL (depending on what version of it you have) may verticlaly cluster
data for each day. If so, select the chart, then select Chart | Chart
Options... | Axes tab. Set the Category (X) values options to
'Category' (it is probably Automatic or Time-Scale).

As far as semi-log charts go, just create the chart of interest without
any log scale. Now, double-click the y-axis and in the Scale tab check
the 'Logarithmic scale' option.

Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site


Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <0bdd01c35768$4b966a70$ XXXX@XXXXX.COM >,

Similar Threads:

1.Bar graph and stacked bar graph on same graph

This is a strange request.
I know how to do graphs with multiple y-axis, but I've been asked to graph 5 
columns of data. The first 3 columns as a bar graph on the left y-axis and 
the last 2 columns as a stacked-bar graph on the right y-axis.
Can this be done? If so, how?
Thanks for the help

2.smaller scale for a semi-log graph possible?

I need the x-axis scale on a semi-log graph to focus in on a smaller area 
other than 1, 10, 100, etc.  When i plot my data, its practically a vertical 
line and would not have enough meaing to my clients so they would be able to 
read it.  So, we currently manually draw the graph.  My data only covers a 
max of 20 units, usually smaller (ex: 18-29 interval for x values).  

3.How to plot semi log graph in Excel?

I want to plot a semi log plot in excel along with grid lines. Can anyone 
tell how to do?

4.Excel should have semi-log graph plotting

5.semi log graphs

I am interested in making Semi-log graphs with the X axis having the log 
scale. I understand that this can be done in XY scatter. 

My x-axis values range from .002 to .312
Do i still need to format my X-axis with a MAX of 10?
Is there a method to set the minor units on my X-axis to smaller increments 
? (i.e.   .001)

Can I zoom in on my graph in my area of interest if i use a MAX 10 x axis?

Does the Trendline equation, slope and intercept formulas used with linear 
graphs function with semilog graphs?  With linear graphs i made a standard 
curve with known x and y values and then input the y value of an unknown and 
solved for x using the trendline equation. Does this work with semi-log?

Semi log challenged, 
dr chuck

6. How should I draw graph in Semi-log sheet

7. Semi-log graph template

8. How do I do a semi-log graph?

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 64 guest