[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ACCESS 2007/2010 CHARTS... WTF?!?!

Posted on 2010-11-24
5
Medium Priority
?
476 Views
Last Modified: 2012-05-10
Does anyone knows where I can find a manual on how to deal with those annoying Access charts that, honestly, seem to have been programmed by a total retard? I'm used to dealing with charts in Excel, and this is just getting to my nerves. I can't believe it's so LAME.

Thanks a lot if you have any suggestions! :)
0
Comment
Question by:Hikarus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34207597
"where I can find a manual on how to deal with those annoying Access charts..."

Clearly define what "Deal with"means?

(Create?, Edit?, Modify?, ...etc)

If you want to edit any chart component:
Open the Form/Report in Design View
Right-Click the chart and select: Chart Object-->Edit
Once you are in this "edit" mode, you can right click any chart object to modify it.
(Just like you can in Excel)

JeffCoachman
0
 

Author Comment

by:Hikarus
ID: 34213750
I just take the Excel charts as a reference, and in comparison it seems that those in access are unbelievably precarious and lame. It's absolutely NOT like in excel.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34214245
"it seems that those in access are unbelievably precarious and lame."
Again, you need to be a bit more specific as to what you men by "precarious and lame"
Please provide specific example of both...

You have also not responded to my previous request for what you men by:
    "how to deal with those annoying Access charts"
"Deal with" in what way? (edit, create, ...etc)


The difference between the two stems from the fact that (even though they both share the same charting "Engine") Excel and Access are two totally different programs in the way you have to "Edit" the charts.

In Excel, the chart is it's own "Object" and you can edit it directly.

In Access the chart object "Lives" in a Form or Report, so first you must go into Design view of the Form/Report, *then* go into "Edit View" of the chart.

That being said, staring with Office 2007, Excel charts have been enhanced greatly in terms of the graphical capabilities of the charts (Highlighting, 3D effects, Shadowing, ...etc)

While Access seems to be stuck, graphically, in Office 2003 mode...
:-(
On the other hand, things like creating charts for individual Customers requires minimal effort in Access, but may require special formulas in Excel.

The wizard used to create the charts are also dis-similar.
The main reason for this is that Excel will plot all the points by default.
Access will attempt to "Summarize" the data by default.
This is because, theoretically, an Access dataset can contain "Billions" of records, whereas in Excel the new max is still only about 1 million.

Finally, ...Excel will chart the data As-Is, meaning that you can have a nonstandard layout in Excel and still create a chart.
Access requires a strict "table" structure (Records in the rows, Fields in the columns)

In conclusion, I will say that I have never come across a chart in Excel, that I could not replicate in Access.

;-)

JeffCoachman
0
 

Author Comment

by:Hikarus
ID: 35146334
do you know of any online manual for access charts?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35148126
See this perhaps:
http://www.vb123.com.au/toolbox/09_access/access2007charting.htm
You can do a search on YouTube for a video as well.

You can see this book too:
http://www.amazon.com/Microsoft-Office-Access-Reports-Queries/dp/0789736691/ref=sr_1_1?ie=UTF8&qid=1300284963&sr=8-1

Keep in mind that any online manual may be generic, due to the nature of charting in general.

But again, if you could provide a specific example of what you are finding difficult...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question