Chart

In A column I have dates (DD-MMM-YYYY format), in B column I have low 
values, in C column high values. I want to create a chart that shows the 
values for each day and have the dates in the X axis.

What I've done is highlight the B and C column values, and choosing 
Category High-Low to construct the chart, but could not include the 
dates in A column. When I tried to highlight A, B, and C, the chart 
wasn't OK.

Also, I would like to reverse the direction of the chart showing the 
bottom values on the left, since the dates start at the bottom.

Thanks,

Eustace

-- 
JavaScript Date Calculator
http://www.geocities.com/emfrilingos/tm/datecalc.html

On 2007.02.19 08:55 lemoto wrote:
> Eustace:
>> In A column I have dates (DD-MMM-YYYY format), in B column I have low 
>> values, in C column high values. I want to create a chart that shows
the 
>> values for each day and have the dates in the X axis.
> 
> I constructed a simple example:
> http://files.myopera.com/lemoto/blog/capt004.jpg
>  
> I highlighted A..C, used QuickChart, chose High-Low Type, manually changed

> Source Data to suit, and chose <Skip 3> X-Axis Labels.
> 
> What here does not suit?
> 
Please explain what you mean by "manually changed Source Data to suit"

and where did you find the option <Skip 3> X-Axis Labels. When I create 
a chart with QuickChart, the chart created has a thick red horizontal 
separating line with Y-Axis labels, above it on the left corresponding 
to the B and C column data, and below it on the right ranging from 0 to 
40000, which should correspond the dates. How did you make the dates go 
the X-Axis?

Then, if I rightclick on the chart and choose Gallery > Category > High 
Low, the chart does not show any data.

>> Also, I would like to reverse the direction of the chart showing the 
>> bottom values on the left, since the dates start at the bottom.
> 
> I do not understand this, perhaps because of the way I set up the data,or 
> the Chart, or both. The arrangement of the data determines the arrangement

> of the Chart; nothing else is possible.

I solved the problem by sorting the data according to the A column, so 
the first date is on the first line, and the chart changed automatically.

Thanks,

Eustace

-- 
JavaScript Date Calculator - Code with a historian's touch!
http://www.geocities.com/emfrilingos/tm/datecalc.html

Eustace:
> In A column I have dates (DD-MMM-YYYY format), in B column I have low 
> values, in C column high values. I want to create a chart that shows the 
> values for each day and have the dates in the X axis.

I constructed a simple example:
http://files.myopera.com/lemoto/blog/capt004.jpg
 
I highlighted A..C, used QuickChart, chose High-Low Type, manually changed 
Source Data to suit, and chose <Skip 3> X-Axis Labels.

What here does not suit?

> Also, I would like to reverse the direction of the chart showing the 
> bottom values on the left, since the dates start at the bottom.

I do not understand this, perhaps because of the way I set up the data,or 
the Chart, or both. The arrangement of the data determines the arrangement 
of the Chart; nothing else is possible.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Eustace:
> Please explain what you mean by "manually changed Source Data to
suit" 

Chart - Edit - right-click - <Source Data>
 - alter the entries for Series 1 and 2 and X-Axis Labels.

In the jpg you see the three columns of data that I specified.
A = X-Axis, B and C are for Series 1 and 2.
If you act similarly, the Chart appearance will change accordingly.

To specify, you can use the Range Picker (arrow in a grey box, in the R 
of the Edit Box).

> and where did you find the option <Skip 3> X-Axis Labels.

Chart - Edit - select X-Axis - right-click - X-Axis Properties
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

On 2007.02.19 13:03 lemoto wrote:
> Eustace:
>> Please explain what you mean by "manually changed Source Data to
suit" 
> 
> Chart - Edit - right-click - <Source Data>
>  - alter the entries for Series 1 and 2 and X-Axis Labels.
> 
> In the jpg you see the three columns of data that I specified.
> A = X-Axis, B and C are for Series 1 and 2.
> If you act similarly, the Chart appearance will change accordingly.
> 
> To specify, you can use the Range Picker (arrow in a grey box, in the R 
> of the Edit Box).
> 
>> and where did you find the option <Skip 3> X-Axis Labels.
> 
> Chart - Edit - select X-Axis - right-click - X-Axis Properties

The problem eventually was that I hadn't checked "Automatically skip 
labels". Once I checked it, the labels appeared, though I really don't 
understand why.

Now, how can I specify that there will be labels every 1 month (instead 
of 34 days that is now, dividing the x-axis into 6 segments)?

Thanks,

Eustace