Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Bar Chart
I'm trying to create a bar chart with data from companies that spanning an
entire year, but displaying sales for each week. The sales data shows data for 1/1, then 1/2-1/8, 1/9-1/15, 1/16-1/22, etc... I created the chart using the wizard, used data from a sheet and all bars are created, but displaying each bar as 1-53 (meaning wk 1-53) because I left the default primary axis, category (x) axis at auto. My problem begins when i change that option from automatic to time-scale. The chart at that point still looks the same, but when I try to edit the Category Axis, the default scale is 1/1/1900-2/22/1900; major 1 day; minor 1 day. When i change the maximum to 12/31 and change major unit at 7 days, it won't take it. it defaults back to 2/22/1900. is there a limit here? thanks in advance |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Bar Chart
On Mon, 25 Aug 2008, in microsoft.public.excel.charting,
bronxbabe said: I'm trying to create a bar chart with data from companies that spanning an entire year, but displaying sales for each week. The sales data shows data for 1/1, then 1/2-1/8, 1/9-1/15, 1/16-1/22, etc... I created the chart using the wizard, used data from a sheet and all bars are created, but displaying each bar as 1-53 (meaning wk 1-53) because I left the default primary axis, category (x) axis at auto. Temporarily remove the heading above the "weeks" column at the left before running the wizard, then put it back again when you've created your chart. The wizard looks for a block of blank cells at the top left to decide what (and how many) rows and columns to use as its series names and category axis. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating Bar Chart
Does your data look like "1/2-1/8", "1/9-1/15", etc.? Excel doesn't know
these are date ranges, it thinks they are category text labels, and assigns them values of 1 to N. You could use just the last date in each grouping, and Excel will accept the dates as dates. Note that the bar chart will not look very good, because for each weekly data point (bar), there will be six days without data, and thus the gaps between bars will be wide. But this kind of data is best in a line chart anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "bronxbabe" wrote in message ... I'm trying to create a bar chart with data from companies that spanning an entire year, but displaying sales for each week. The sales data shows data for 1/1, then 1/2-1/8, 1/9-1/15, 1/16-1/22, etc... I created the chart using the wizard, used data from a sheet and all bars are created, but displaying each bar as 1-53 (meaning wk 1-53) because I left the default primary axis, category (x) axis at auto. My problem begins when i change that option from automatic to time-scale. The chart at that point still looks the same, but when I try to edit the Category Axis, the default scale is 1/1/1900-2/22/1900; major 1 day; minor 1 day. When i change the maximum to 12/31 and change major unit at 7 days, it won't take it. it defaults back to 2/22/1900. is there a limit here? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
Creating a Pie Chart | Charts and Charting in Excel | |||
creating a pie chart | Charts and Charting in Excel | |||
Creating a chart | Charts and Charting in Excel | |||
creating an x,y chart | Charts and Charting in Excel |